Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.
Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Learn about upcoming Qlik related events, webinars and local meetups.
Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.
Hear directly from Qlik employees in our eight unique blogs. Check out the new Architecture Deep Dive Blog!
Find a forum to ask a question or start a discussion.
Discussion Boards and Documents for Qlik Services.
Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.
Discussion board and documents related to Qlik Associative Big Data Index.
Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.
I can't figure this one out. Simplified version of the table I'm processing is: ID, Team
Consider these tickets and team assignments. Everying "A*" is the same department (the number indicates a subteam).
I'm trying to calculate the count of IDs that were handled with department A without ever going to a different group.
In the example above the result would be 2 (ID 2 and 3)
I got this working in the SQL DB (subquery), but I need it Qlik Sense as a formula for a KPI.
Help is much appreciated.
I wish to compute the cumulative value for a measure.
In the below table I want to compute the cumulative value for the sales.
can you kindly advise , thanks for the help.
|Product||Month||Work day||Sales||Cumulative (expected result)|
Currently, I have a table as below and I need to put filter in the expression in Qlik Sense
Can you please help to write a filter expression to get the only one record which is not in Done status and having least date,
From my below table I wanted to get the Name as Record 2 as the status is not Done and the date is smallest of the records which are not in done status
I am trying to understand why set analysis drops some rows when chart dimension value is null and measure field exists in different than chart dimension field.
I have attached sample app, very similar to what we have in production app. The main question is, why left chart shows count 2 against null dimension but right one shows 1 against null dimension.
I observed if I replace set analysis expression with IF statement, both chart shows 2 against null dimension value.
Any help will be highly appreciated.
Precisava identificar as 10 primeiras iterações realizadas por determinado usuário.
Estamos efetuando esse processo em 3 passos
Como a tabela contém mais de 100 milhões de registros, na hora de realizar a ordenação e o índice sequencial, a tabela fica por mais de 48 horas sem finalizar o processo.
Alguém sabe uma maneira de otimizar essa situação?
Segue um resumo do script realizado.
//Ordenando e Criando índice
AutoNumber(RowNo(), usu_codigo) as indice_usuario
Resident [Tabela 1]
Order By usu_codigo, data;
//Selecionando as 10 primeiras interações
Resident [Tabela 2]
Where indice_usuario <= 10;
Drop Table [Tabela 2];
I have one Qlikview application in which i got request from client that certain data can only be available to certain users.
So i have used row level section access security.But i have one doubt regarding it.
If there are 100 users are using that application and i want 15 users to have access of certain data only.
so for applying security for 10-15 users, i have to create hidden script for it. So is it necessary to write the code about the access of all the 100 users in that script?like 85 users have admin access and other 15 users have specific area of access.
Is there any other way where i can write about those 15 users only that can use certain data only? because in future there are possibilities to increase the count of users. So every time I need to change the code.
I am new to QS and try to load two excel files. Each excel files contain three sheets. These excel files name 2018 and 2019. The sheets name for those excel files are 07, 08 and 09. I would like to create two Tables in QS but not sure why it will combine into one Table after loading below script. Can anyone help me to check? Thank you.
LET vStartSheetNumber2019 = 7;
LET vEndSheetNumber2019 = 9;
FOR index2019 = vStartSheetNumber2019 TO vEndSheetNumber2019
'2019' as [Year]
(ooxml, embedded labels, table is [$(index2019)]);
LET vStartSheetNumber2018 = 7;
LET vEndSheetNumber2018 = 9;
FOR index2018 = vStartSheetNumber2018 TO vEndSheetNumber2018
'2018' as [Year]
(ooxml, embedded labels, table is [$(index2018)]);
We have installed Qlik Sense Mobile on Apple Ipad.
As per the rules provided by Qlik, we have done changes in QMC (Offline access, Client Authentication Link, enabled TLS 1.2).
We are getting issue "Server login Attempt failed". Please help us to close this issue.
Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.
This group hosts information related to the Qlik Deployment Framework (QDF).
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases
Participate in an upcoming Qlik related event, webinar, or local meetup.
Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem