Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,993 online

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.


Introducing Qlik Gallery

Announcing the newest addition to the Qlik Community, Qlik Gallery!

Qlik Gallery is all about sharing – apps, outcomes, and ideas. This is your space to learn from each other as Qlik users, fans, thought leaders and data enthusiasts

Recent Discussions

  • New to Qlik Sense

    Counting with multiple condition

    Hello,I can't figure this one out. Simplified version of the table I'm processing is: ID, TeamIDTeam1A11A21B22A12A22A13A13A33A24A14B14C2 Consider thes... Show More

    Hello,

    I can't figure this one out. Simplified version of the table I'm processing is: ID, Team

    IDTeam
    1A1
    1A2
    1B2
    2A1
    2A2
    2A1
    3A1
    3A3
    3A2
    4A1
    4B1
    4C2

     

    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.

    Show Less
  • New to Qlik Sense

    Cumulative measure

    Dear All, 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 ... Show More

    Dear All,

     

    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.

     

    ProductMonthWork daySalesCumulative (expected result)
    AJan133
    AJan247
    AJan3512
    AJan4618
    BJan144
    BJan226
    BJan339
    BJan4413
    AFeb122
    AFeb235
    AFeb3712
    AFeb4921
    BFeb11111
    BFeb21323
    BFeb31437
    BFeb41552

     

    Show Less
  • New to Qlik Sense

    Qlik Sense - Filter in Measure expression

    Hello Team,Currently, I have a table as below and I need to put filter in the expression in Qlik SenseCan you please help to write a filter expression... Show More

    Hello Team,

    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

    IDNameDateStatus
    1Record 12019-10-08WIP
    2Record 22019-09-18ASSIGNED
    3Record 32019-08-15DONE
    Show Less
  • Qlik Sense App Development

    How Set Analysis works when measure field exists in different table and Dimensio...

    Hi,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 dime... Show More

    Hi,

    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.

    clipboard_image_0.png

     

    @Henric_Cronström 

    @swuehl 

    @stevedark 

    @rwunderlich 

    @jagan 

    @Gysbert_Wassenaar 

    @sunny_talwar 

    Any help will be highly appreciated.

    Thanks,

    DJ

     

     

    Show Less
  • New to QlikView

    Change Qlik Community Profile Email Address

    I have changed companies and would like to change the email address in my profile (for obvious reasons).How do I do that?ThanksJeff
  • Community Corner

    Identificando as 10 primeiras iterações realizadas por determinado usuário

    Precisava identificar as 10 primeiras iterações realizadas por determinado usuário.Estamos efetuando esse processo em 3 passosOrdenação por usuário e ... Show More

    Precisava identificar as 10 primeiras iterações realizadas por determinado usuário.

    Estamos efetuando esse processo em 3 passos

    • Ordenação por usuário e data de iteração;
    • Criação de um índice sequencial novamente por usuário e data de iteração;
    • Leitura dos índices de 1 a 10.

    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.

    [Tabela 1]:
    LOAD *
    FROM e:/metricas.qvd(qvd);

    //Ordenando e Criando índice
    [Tabela 2]:
    Load usu_codigo,
         data,

         acao,
         AutoNumber(RowNo(), usu_codigo) as indice_usuario
    Resident [Tabela 1]
    Order By usu_codigo, data;


    //Selecionando as 10 primeiras interações
    [Tabela 3]:
    Load usu_codigo,
         data,

         acao,
         indice_usuario
    Resident [Tabela 2]
    Where indice_usuario <= 10;

    Drop Table [Tabela 2];

    Show Less
  • QlikView App Development

    Qlikview: Row level security implementation

    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 s... Show More

    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.

    Show Less
  • New to Qlik Sense

    Load Multiple Excel Sheets

    Hi All, 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 f... Show More

    Hi All,

     

    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:
    LOAD
    *,
    '2019' as [Year]
    FROM [lib://Data/2019.xlsx]
    (ooxml, embedded labels, table is [$(index2019)]);
    Next


    LET vStartSheetNumber2018 = 7;
    LET vEndSheetNumber2018 = 9;
    FOR index2018 = vStartSheetNumber2018 TO vEndSheetNumber2018

    2018:
    LOAD
    *,
    '2018' as [Year]
    FROM [lib://Data/2018.xlsx]
    (ooxml, embedded labels, table is [$(index2018)]);
    Next

    Show Less
  • Qlik Sense Mobile Discussions

    server login attempt failed

    Hi,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 Authentic... Show More

    Hi,

    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.

    Thanks,

    Kalyan

    Show Less
  • New to Qlik Sense

    Please suggest best data model for the below tables

    Hi all, Please help me in preparation of best data model which i was mentioned in the attachment code table, Function, Region, Country table are same ... Show More
    Hi all, Please help me in preparation of best data model which i was mentioned in the attachment code table, Function, Region, Country table are same in left side table and right side tables please find my attachment and give suitable data model advise Thanks in Advance ... Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Qlik Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar