Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Recent Discussions
-
Qlik Alerting - User Group 관련 질의
안녕하세요. 당사에서는 Qlik을 단순 Dashboard 조회 목적이 아닌 사용자 Role 기반 Dashboard 및 Alerting/NPrinting 서비스로 활용하고 있습니다. 이에 따라 Role별로 조회 가능한 Qlik Dashboard와 수신 가능한 Aler... Show More안녕하세요.
당사에서는 Qlik을 단순 Dashboard 조회 목적이 아닌 사용자 Role 기반 Dashboard 및 Alerting/NPrinting 서비스로 활용하고 있습니다.
이에 따라 Role별로 조회 가능한 Qlik Dashboard와 수신 가능한 Alerting/NPrinting을 구분하여 관리하는 것이 중요합니다.
현재 Qlik Alerting의 User Group 관리 및 AD Security Group 연동과 관련하여 아래와 같은 개선사항을 요청드립니다.
1. User groups 목록 조회 제한 개선
현재 Admin > User management > User groups 경로에서 회사 내 Role별로 User Group을 생성하여 관리하고 있습니다.
당사에서는 약 80개의 Role을 User Group으로 생성하였으나, User groups 페이지에서는 최대 50개의 Group만 조회되고 있습니다.
또한 Alert 리스트와 달리 User groups 페이지에는 Show More 또는 Pagination과 같은 추가 목록 조회 기능이 제공되지 않아, 50개를 초과하는 전체 Group 목록을 확인하기 어렵습니다.
개선 요청
User groups 페이지에서도 생성된 전체 User Group을 조회할 수 있도록 기능 개선을 요청드립니다.
예를 들어 아래와 같은 기능이 제공되면 좋을 것 같습니다.
- Pagination 또는 Show More
- 전체 Group 목록 조회 가능해야 함
2. User Group 검색 기능 개선
Alert의 수신자를 설정할 때 User Group의 개수가 많기 때문에 검색 기능을 사용하고 있습니다.
그러나 현재 Alert의 수신자 설정 화면에서는 Group Name의 일부만 입력하여 검색할 경우 검색 결과가 조회되지 않는 문제 및 Assigned된 Group 리스트가 일부만 보이는 문제가 있습니다.
예를 들어
ADMIN이라는 Group을 검색하기 위해ADM만 입력하면ADMINGroup이 검색 결과에 표시되지 않습니다.반면, Admin > User management > User groups 화면에서는
ADM과 같이 Group Name의 일부만 입력해도 해당 문자열이 포함된 Group들이 정상적으로 검색됩니다.개선 요청
Alert의 수신자 설정 화면에서도 User groups 관리 화면과 동일하게 Partial Match / Contains 방식의 검색이 가능하도록 개선을 요청드립니다.
예를 들어:
- 검색어:
ADM - 검색 결과:
ADMIN,ADMINISTRATOR,ADM_ENGINEER등ADM을 포함하는 모든 Group
즉, Group의 정확한 Full Name을 입력하지 않더라도 검색어가 Group Name에 포함되어 있으면 해당 Group이 검색 결과에 표시되도록 개선되면 좋겠습니다.
3. AD Security Group과 Qlik / Qlik Alerting / Qlik NPrinting 간 자동 연동
당사에서는 AD Manager를 통해 특정 OU 하위에 Role별 Security Group을 구성하여 사용하고 있습니다.
각 Security Group에는 해당 Role을 보유한 구성원의 AD ID가 포함되어 있으며, 따라서 AD에서는 각 사용자가 어떤 Role에 속해 있는지에 대한 정보를 이미 관리하고 있습니다.
현재는 이러한 AD Security Group 정보를 Qlik, Qlik Alerting, Qlik NPrinting에서 직접 활용하기 어려운 것으로 보입니다.
그 결과, 현재는 관리자가 Qlik Alerting에 Role별 User Group을 별도로 생성하고, 인사이동이나 조직변경이 발생할 때마다 각 Group의 구성원을 수동으로 수정해야 합니다.
개선 요청
AD의 Security Group 정보를 Qlik 플랫폼에서 직접 활용할 수 있도록 AD Security Group과 Qlik / Qlik Alerting / Qlik NPrinting 간의 연동 기능을 제공해 주실 것을 요청드립니다.
예를 들어 아래와 같은 방식의 연동을 고려해 주시면 좋겠습니다.
AD Security Group
→ Role별 구성원 관리
→ Qlik / Qlik Alerting / Qlik NPrinting에서 해당 Group 정보 활용이를 통해 관리자가 각 제품에서 User Group 및 사용자 정보를 개별적으로 관리하지 않고, 회사 AD의 Role 정보를 Single Source of Truth로 활용할 수 있을 것으로 생각합니다.
특히 당사와 같이 Qlik을 Role-based Dashboard 및 Notification Platform으로 활용하는 환경에서는 다음과 같은 기능이 중요합니다.
- Role별 Qlik Dashboard 접근 권한 관리
- Role별 Qlik Alerting 수신자 설정
- Role별 Qlik NPrinting 수신자 설정
- 조직/인사변동 발생 시 사용자 권한 및 수신자 정보 자동 반영
- 관리자의 수동 User Group 관리 업무 최소화
현재와 같이 관리자가 각 시스템에서 Role 및 사용자를 수동으로 관리하는 방식은 Role 및 사용자 수가 증가할수록 관리 부담과 운영 오류 가능성이 커질 수 있습니다.
따라서 AD Security Group을 Qlik 플랫폼의 User Group과 연계하여 자동으로 동기화할 수 있는 기능을 제공한다면, Enterprise 환경에서 Qlik을 Role 기반으로 운영하는 고객에게 상당히 유용한 기능이 될 것으로 생각합니다.
-
Qlik Sense repository service consuming full RAM in the central node
Hi All,Qlik Sense repository service is consuming full memory in the server and causing node down.Any idea why would repository service would consume ... Show MoreHi All,
Qlik Sense repository service is consuming full memory in the server and causing node down.
Any idea why would repository service would consume full memory?
Current observation is repository service is gradually consuming full memory in the server. From resource monitor I could see that most memory is consumed while connecting to the dedicated postgres repository database.
Kindly provide any suggestion where should I start checking ?
Thanks.
-
Not all records loaded during reload.
Hi All,I've noticed that after the reload of today that a lot of records are not loaded in the dashboard.The selection is the same as the previous day... Show MoreHi All,
I've noticed that after the reload of today that a lot of records are not loaded in the dashboard.
The selection is the same as the previous days and also the file was available.
This is a part of the log of Yesterday.
I load 2 files in the table.
In the first file are 33,598,635 records.
The second file 56,329,459 - 33,598,635 = 22,730,824 records.
33,598,635 lines fetched
20260903T112456.545+0200 1230 next
20260903T112456.546+0200 1180 let vFile = 'TRX_H_' & 2026 & '.QVD'
20260903T112456.550+0200 1181 concatenate
20260903T112456.550+0200 1182 TRX_H:
20260903T112456.550+0200 1183 LOAD
20260903T112456.550+0200 1184 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXD') as Key_TRXD,
20260903T112456.550+0200 1185 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXF') as Key_TRXF,
20260903T112456.550+0200 1186
20260903T112456.550+0200 1187
20260903T112456.550+0200 1188
20260903T112456.550+0200 1189
20260903T112456.550+0200 1190
20260903T112456.550+0200 1191 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'),TRX_H_DTMM,TRX_H_DTMD)) as Datumtransactie,
20260903T112456.550+0200 1192
20260903T112456.550+0200 1193 if(0 = 1,
20260903T112456.550+0200 1194 Applymap('PBY_Map',num(TRX_H_STNR,'00000') & Left(num(TRX_H_REF,'0000000000'),4),num(Today())),
20260903T112456.550+0200 1195 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00') ,TRX_H_DTMM , TRX_H_DTMD))) as DatumNum,
20260903T112456.550+0200 1196
20260903T112456.550+0200 1197
20260903T112456.550+0200 1198 Left(num(TRX_H_UURT,'000000'),2) & ':' & Mid(num(TRX_H_UURT,'000000'),3,2) as Uur_Getankt,
20260903T112456.550+0200 1199
20260903T112456.550+0200 1200 Left(num(TRX_H_UURT,'000000'),2) as Uur,
20260903T112456.550+0200 1201 Left(num(TRX_H_UURT,'000000'),2) & ':' & mid(num(TRX_H_UURT,'000000'),3,2) & ':' & left(num(TRX_H_UURT,'000000'),2) as UurSec,
20260903T112456.550+0200 1202 num(TRX_H_STNR,'00000') as Stationnummer,
20260903T112456.550+0200 1203
20260903T112456.550+0200 1204
20260903T112456.550+0200 1205
20260903T112456.550+0200 1206 if(TRX_H_SHF=0, 'Terminal', TRX_H_SHF) as Shift_Id,
20260903T112456.550+0200 1207 TRX_H_STNR & '-' & if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', trim(TRX_H_OPID)) as Operator_Id,
20260903T112456.550+0200 1208 if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', 'Shop') as Terminal_Shop,
20260903T112456.550+0200 1209
20260903T112456.550+0200 1210
20260903T112456.550+0200 1211
20260903T112456.550+0200 1212
20260903T112456.550+0200 1213 TRX_H_CUST as KeyCust,
20260903T112456.550+0200 1214 if(len(trim(TRX_H_ID)) > 0,TRX_H_ID, TRX_H_PAN) as Firmakaart,
20260903T112456.550+0200 1215 'KL' & num(TRX_H_CUST,'00000') as Klant_Lev_Nummer,
20260903T112456.550+0200 1216 applymap('KLANT_MAP', 'KL' & num(TRX_H_CUST,'00000'),'UNKNOWN') as Klant_Naamtest,
20260903T112456.550+0200 1217 TRX_H_PAN,
20260903T112456.550+0200 1218
20260903T112456.550+0200 1219 TRX_H_ODO as Km_Stand,
20260903T112456.550+0200 1220
20260903T112456.550+0200 1221 TRX_H_CARR as Plaatnummer,
20260903T112456.550+0200 1222 TRX_H_TTNA as TRXHTotal
20260903T112456.550+0200 1223 FROM
20260903T112456.550+0200 1224 [..\03_QVD\TRX_H_2026.QVD]
20260903T112456.550+0200 1225 (qvd)
20260903T112456.550+0200 1226 where num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'), TRX_H_DTMM,TRX_H_DTMD)) >= 45658 and len(trim(TRX_H_STNR)) > 0 and TRX_H_STNR <= '1000'
20260903T112456.555+0200 19 fields found: Key_TRXD, Key_TRXF, Datumtransactie, DatumNum, Uur_Getankt, Uur, UurSec, Stationnummer, Shift_Id, Operator_Id, Terminal_Shop, KeyCust, Firmakaart, Klant_Lev_Nummer, Klant_Naamtest, TRX_H_PAN, Km_Stand, Plaatnummer, TRXHTotal,
20260903T114353.975+0200 56,329,459 lines fetchedThis is the a part of the log of the reload of today.
Also in the first file I have less records then the day before (it should be more)
And in the second file I have almost no records loaded.
30,883,385 lines fetched
20260904T062431.542+0200 1230 next
20260904T062431.559+0200 1180 let vFile = 'TRX_H_' & 2026 & '.QVD'
20260904T062431.590+0200 1181 concatenate
20260904T062431.590+0200 1182 TRX_H:
20260904T062431.590+0200 1183 LOAD
20260904T062431.590+0200 1184 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXD') as Key_TRXD,
20260904T062431.590+0200 1185 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXF') as Key_TRXF,
20260904T062431.590+0200 1186
20260904T062431.590+0200 1187
20260904T062431.590+0200 1188
20260904T062431.590+0200 1189
20260904T062431.590+0200 1190
20260904T062431.590+0200 1191 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'),TRX_H_DTMM,TRX_H_DTMD)) as Datumtransactie,
20260904T062431.590+0200 1192
20260904T062431.590+0200 1193 if(0 = 1,
20260904T062431.590+0200 1194 Applymap('PBY_Map',num(TRX_H_STNR,'00000') & Left(num(TRX_H_REF,'0000000000'),4),num(Today())),
20260904T062431.590+0200 1195 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00') ,TRX_H_DTMM , TRX_H_DTMD))) as DatumNum,
20260904T062431.591+0200 1196
20260904T062431.591+0200 1197
20260904T062431.591+0200 1198 Left(num(TRX_H_UURT,'000000'),2) & ':' & Mid(num(TRX_H_UURT,'000000'),3,2) as Uur_Getankt,
20260904T062431.591+0200 1199
20260904T062431.591+0200 1200 Left(num(TRX_H_UURT,'000000'),2) as Uur,
20260904T062431.591+0200 1201 Left(num(TRX_H_UURT,'000000'),2) & ':' & mid(num(TRX_H_UURT,'000000'),3,2) & ':' & left(num(TRX_H_UURT,'000000'),2) as UurSec,
20260904T062431.591+0200 1202 num(TRX_H_STNR,'00000') as Stationnummer,
20260904T062431.591+0200 1203
20260904T062431.591+0200 1204
20260904T062431.591+0200 1205
20260904T062431.591+0200 1206 if(TRX_H_SHF=0, 'Terminal', TRX_H_SHF) as Shift_Id,
20260904T062431.591+0200 1207 TRX_H_STNR & '-' & if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', trim(TRX_H_OPID)) as Operator_Id,
20260904T062431.591+0200 1208 if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', 'Shop') as Terminal_Shop,
20260904T062431.591+0200 1209
20260904T062431.591+0200 1210
20260904T062431.591+0200 1211
20260904T062431.591+0200 1212
20260904T062431.591+0200 1213 TRX_H_CUST as KeyCust,
20260904T062431.591+0200 1214 if(len(trim(TRX_H_ID)) > 0,TRX_H_ID, TRX_H_PAN) as Firmakaart,
20260904T062431.591+0200 1215 'KL' & num(TRX_H_CUST,'00000') as Klant_Lev_Nummer,
20260904T062431.591+0200 1216 applymap('KLANT_MAP', 'KL' & num(TRX_H_CUST,'00000'),'UNKNOWN') as Klant_Naamtest,
20260904T062431.591+0200 1217 TRX_H_PAN,
20260904T062431.591+0200 1218
20260904T062431.591+0200 1219 TRX_H_ODO as Km_Stand,
20260904T062431.591+0200 1220
20260904T062431.591+0200 1221 TRX_H_CARR as Plaatnummer,
20260904T062431.591+0200 1222 TRX_H_TTNA as TRXHTotal
20260904T062431.591+0200 1223 FROM
20260904T062431.591+0200 1224 [..\03_QVD\TRX_H_2026.QVD]
20260904T062431.591+0200 1225 (qvd)
20260904T062431.591+0200 1226 where num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'), TRX_H_DTMM,TRX_H_DTMD)) >= 45658 and len(trim(TRX_H_STNR)) > 0 and TRX_H_STNR <= '1000'
20260904T062431.629+0200 19 fields found: Key_TRXD, Key_TRXF, Datumtransactie, DatumNum, Uur_Getankt, Uur, UurSec, Stationnummer, Shift_Id, Operator_Id, Terminal_Shop, KeyCust, Firmakaart, Klant_Lev_Nummer, Klant_Naamtest, TRX_H_PAN, Km_Stand, Plaatnummer, TRXHTotal,
20260904T062456.643+0200 31,170,105 lines fetchedWho has an idea why he is not loading all data?
The data is the transaction header out of a shop. So every day there should be more records.
If I doe now a reload of the trx_h_2026 with the same selections in my desktop, this is the result.
Who can help me with this?
-
Azure Blob storage connection is failing due to large size of csv files
Dear Qlik team,Our goal is to create a replicate task in Qlik Data Integration and the source data is present in Azure Cloud storage. We are capturing... Show MoreDear Qlik team,
Our goal is to create a replicate task in Qlik Data Integration and the source data is present in Azure Cloud storage. We are capturing the data from multiple csv files from Azure blob storage. We have successfully created the connections for other folders/tables and we have replicated the data. But for one particular folder contains csv files which are 1.2 - 1.8 GB each, we are unable to create the connection.
Is there a limitation on file size? or Is there any setting that we need to enable/disable?
-
tSalesforceBulkExec: missing salesforce_id / error in output
Hello, We upgrade this summer our Talend Cloud Studio from 7.3.1 to 8.0.1R2026-06. I'm trying to create a new job to put data in Salesforce using the ... Show MoreHello,
We upgrade this summer our Talend Cloud Studio from 7.3.1 to 8.0.1R2026-06.
I'm trying to create a new job to put data in Salesforce using the tSalesforce bulk components, and specifically the tSalesforceBulkExec.
I put it on the designer, select the existing connection, choose the module to update and import the schema from my tSalesforceOutputBulk in the "Schema".
When I use the MAIN and Reject output of the tSalesforceBulkExec (or check the "Schema MAIN" & "Reject Schema" in Basic Settings), I have the input schema, but the following automatic columns are missing :
- MAIN : salesforce_id & salesforce_created
- Reject : error
Is this a standard behavior or a regression ?
Edit Sept 07 : it also seems that it does not handle well when one/some fields contains lines returns. When everythings was alright in 7.3.1
-
Possible Syntax Error. Dynamic Date for bookmark
Hello good people of the Qlik Community We have a Year drop down and the User can select the Year they want to view. The problem is that it defaults t... Show MoreHello good people of the Qlik Community
We have a Year drop down and the User can select the Year they want to view.
The problem is that it defaults to year 2023 when entering the sheet.
We want to change it to use a dynamic value GL.Year = Year((Today(0)). but when doing so, the expression is blank on the bookmark.
What am I missing?
Here's some screenshots to illustrate. Heres the bookmark
Here's an example where it's hardcoded a year. We don't want a hardcoded year, would like to have Year(Today(0)) to keep it dynamic
I'm able to achieve this using the Action, but it only applies to one sheet in a application. Looking for more of a "global" config where all sheets in the app use Year(today(0)) as the Year selection
Cheers!
-
New video - Manage Qlik Automations with Claude and Qlik MCP Server
Wanted to flag this for anyone working with Qlik Automations: Qlik has added new automation-management tools to the Qlik MCP Server, along with a set ... Show MoreWanted to flag this for anyone working with Qlik Automations: Qlik has added new automation-management tools to the Qlik MCP Server, along with a set of open-source Agentic Skills (qlik-oss/agentic-skills) that teach coding agents how to use them properly.
In this episode of Data Voyagers, I use Claude Code with the Qlik Automation Builder skill to create a Qlik Automation that reloads every Table Recipe in a Shared Space, then go back and edit it, testing along the way so you can see exactly what the agent does at each step.
If you're maintaining automations by hand today, or just want to see what an agent-built one actually looks like under the hood, it's worth the 19 minutes.
Watch it here: https://youtu.be/FwgpjHETWHU
The skills are open source and on GitHub if you want to try them in your own tenant.
Regards,Mark Costa
-
High Five - September 2026, André Hamon
Featured Member · September 2026 Meet André, our September Featured Member This month, all eyes are on André, whose journey from New Zealand's... Show MoreFeatured Member · September 2026Meet André, our September Featured Member
This month, all eyes are on André, whose journey from New Zealand's insurance industry to the heart of London's data community shows exactly the kind of curiosity and drive that makes a great Qlik Community member. A dedicated Qlik customer for years, André brings real, hands-on experience to every thread he touches, and he's not shy about sharing it. We're thrilled to name him our Featured Member for September 2026!
André spent the last decade working in general insurance in New Zealand, starting out in underwriting before moving into BI and data. Most recently, he worked at Ando Insurance, where he worked across Qlik Cloud, Snowflake, and Salesforce, and embedded AI into BI workflows. While there, André had the opportunity to speak at Qlik Connect in 2024, and in 2025, Ando Insurance was recognized with the Qlik Organizational Transformation award at the Qlik Digital Transformation Awards Australia & New Zealand in Sydney.
“Explaining a set analysis expression, a load script pattern, or an automation block to someone else forces me to properly understand it.”
— André
For André, the Community has always been more than a resource, it's where he's worked through some of his toughest Qlik challenges over the years, usually by finding a thread where someone had already hit the same wall. Now, he pays it forward by answering questions himself, and he says he picks up plenty from other people's answers along the way too.
Outside of Qlik, André loves building things just for the fun of it, from a Raspberry Pi dev server to small apps and even a Qlik extension or two. He's also working on learning French (even after two months living in Lyon), and he's an avid tennis fan.
Thank you, André!
Thank you for bringing your expertise and generosity to the Qlik Community. Please join us in celebrating André as our September 2026 Featured Member, leave a comment below!
-
[ARTICLE] How to identify duplicated fields in Qlik Cloud ?
After a long wait, Qlik Cloud has finally introduced a feature that can save a LOT of time for developers! When loading data, if a field is duplicated... Show MoreAfter a long wait, Qlik Cloud has finally introduced a feature that can save a LOT of time for developers!
When loading data, if a field is duplicated, Qlik now tells you exactly which field is causing the problem.
Before this update, I had to manually search for the duplicated field — and sometimes there were hundreds of fields to go through.
Now? Qlik simply shows you the exact name of the duplicated field.
Less manual work.
Less frustration.
More time to focus on what really matters: building things.
This may look like a small improvement, but for anyone working with large data loads, it’s a BIG deal!
-
Qlik Sense | Popup Message
Hi All,Basically am looking out for dynamic message box popup functionality where I can display any dynamic message externally.There should not be any... Show MoreHi All,
Basically am looking out for dynamic message box popup functionality where I can display any dynamic message externally.
There should not be any dependency on script/code changes from backend or front end in app.
I am trying to make changes in .txt or .xlsx external file which will be directly visible into app.
If i enter and dynamic message in .txt file and enable show option then it will show popup message on dashboard homepage and if i disable show option then popup message will be disappeared.
Regards,
KK
AGENTIC AI STARTS WITH WHAT YOU ALREADY HAVE
Here’s your agentic AI readiness check. (Got Qlik? You're closer than you think.)
INTRODUCING AGENTIC AI THAT'S BUILT FOR THE BUILDERS
Walk through six new AI capabilities now generally available in Qlik and start applying agentic data engineering to your team’s workflows.
QLIK LEARNING VOYAGE 2026
Set your course for six weeks of expert-led sessions on data, analytics, and AI — available on demand.
The Evolution of the Data Engineer Whitepaper
Built for the builders: Modern data engineering is AI powered — and engineer led.
LET'S TALK ENTERPRISE AI
The pilot-to-production gap is real. From fragmented data to governance gaps Qlik and AWS break down what’s holding your enterprise AI back — and how to solve them.
Your journey awaits! Join us by Logging in and let the adventure begin.
