Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 238,285 members
  • 2,800 online
  • 2,020,748 posts
  • 151,947 Solutions
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Count new records (based on date range criteria)

    Hi to all.  I try to count in a date range the new registration. I want to calculate, for values >0 the number of customers that got record for the fi... Show More

    Hi to all. 

    I try to count in a date range the new registration. I want to calculate, for values >0 the number of customers that got record for the first time.

    In excel, by manual handle I get the following data. Note I use Month as dimension

    Row Labels

    sep

    oct

    nov

    350

    203

    44

    15

    351

    162

    46

    31

    352

    197

    39

    13

    353

    76

    49

    26

    355

    61

    102

    17

    356

    43

    102

    17

    357

    0

    55

    107

    Grand Total

    742

    437

    226

     

    In Qlik using date as dimension I get the following result

     

    jorgie_0-1733299796143.png

     

     

    I need help in order to have the correct results.

    Also it would be amazing if I could have the capability to check it in weeks or months by setting a range that find new. For example, ii there wasn't any record 100 days before, is a new one

     

    thanks in advance

    Show Less
  • forum

    New to Qlik Analytics

    Leveraging Qlik Analytics for Real-World Data Insights in Critical Industries

    I'm new to Qlik Analytics and excited to explore how it can help with data-driven decisions. I’m particularly interested in using it for industries li... Show More

    I'm new to Qlik Analytics and excited to explore how it can help with data-driven decisions. I’m particularly interested in using it for industries like transportation, where data from various sources, including traffic and incident reports, can provide powerful insights.

    For example, in cities like Phoenix, where car accidents are a frequent issue, having accurate and up-to-date data visualization could help authorities or legal teams—like Phoenix car accident attorneys—better understand patterns and improve response strategies.

    I’d love to hear any beginner tips for using Qlik in this type of real-world scenario or how you’ve tackled similar challenges!

    Show Less
  • forum

    New to Qlik Analytics

    Get the Rank in the Pivot table

    Trying to get the Rank for a specific values in a dimension, which is aggregated by multiple dimensions in the rows and columns in a pivot table.   He... Show More

    Trying to get the Rank for a specific values in a dimension, which is aggregated by multiple dimensions in the rows and columns in a pivot table.

      Here is the example table and expected pivot table results

    Region Product Source Industry FEE Bank Name Year
    India P1 A L1 80 BOA 2023
    India P1 A L2 88 City 2023
    India P2 B L1 23 SriBank 2023
    India P2 B L2 36 HDFC 2023
    USA P1 A L1 28 BOA 2023
    USA P1 A L2 51 City 2023
    USA P2 B L1 87 SriBank 2023
    USA P2 B L2 26 HDFC 2023
    India P1 A L1 20 BOA 2024
    India P1 A L2 23 City 2024
    India P1 A L2 43 SriBank 2024
    India P2 B L2 18 HDFC 2024
    India P2 B L2 68 SriBank 2024
    USA P1 A L1 30 BOA 2024
    USA P1 A L2 35 City 2024
    USA P2 B L1 44 SriBank 2024
    USA P2 B L2 95 HDFC 2024

     

    In the Qlike Sense a Pivot table, dimension rows have Region, Source and Industry. Column has Year and Product Dimensions.
    Please help me to create a measure expression to get the Rank for the 'SriBank' in the BankName table when the 'SriBank' is compared with all other values in the BankName column, and comparing is based on the Sum of Fee. The Pivot table cell values would be the Rank of 'SriBank' by Rows and Column dimensions and Total aggregated by all the columns. 

    Below is the expected pivot output

            Year Product      
          2023 2024
    Region Source Industry 2023 Total P1 P2 2024 Total P1 P2
    Global     2 0 1 1 3 2
    India
    India Total   4     1    
    A Total     0 2 1 1  
      L1            
      L2         1  
    B Total   2   2 1   1
    B L1 1   1      
      L2           2
    USA
    USA Total   1     2    
    A Total              
    A L1            
      L2            
    B Total   1   1 2 2 2
    B L1 1   1     1
      L2            
    Show Less
  • forum

    Connectivity & Data Prep

    [OBDC Connection] MySQL Databases in Chinese Characters

    Hi,Do you have any idea what seems to be the problem in my ODBC connection in Qlik Cloud. I can successfully connect to the MySQL database using ODBC ... Show More

    Hi,

    Do you have any idea what seems to be the problem in my ODBC connection in Qlik Cloud. 

    I can successfully connect to the MySQL database using ODBC connection but when I select data, the databases are in chinese characters.

    Attached here is my config and the list of databases

     

    Show Less
  • forum

    App Development

    The user is missing Create access

    We work with an evaluation form which uses a Vizlib writeback table.Recently we're receiving the following message on it: The user is missing Create a... Show More

    We work with an evaluation form which uses a Vizlib writeback table.
    Recently we're receiving the following message on it:

    The user is missing Create access on the App (with ID: dc76da48-a63a-4f32-8d29-1c9e2791beac) or create apps is disabled on server node. (needed to be able to create a session app)

    I am admin and should have all rights, but I too cannot add new data.

    Any idea where I can fix this?

    Show Less
  • forum

    New! Qlik Answers

    Pivot table Rankin

    Trying to get the Rank for a specific values in a dimension, which is aggregated by multiple dimensions in the rows and columns in a pivot table.   He... Show More

    Trying to get the Rank for a specific values in a dimension, which is aggregated by multiple dimensions in the rows and columns in a pivot table.

      Here is the example table and expected pivot table results

    Region Product Source Industry FEE Bank Name Year
    India P1 A L1 80 BOA 2023
    India P1 A L2 88 City 2023
    India P2 B L1 23 SriBank 2023
    India P2 B L2 36 HDFC 2023
    USA P1 A L1 28 BOA 2023
    USA P1 A L2 51 City 2023
    USA P2 B L1 87 SriBank 2023
    USA P2 B L2 26 HDFC 2023
    India P1 A L1 20 BOA 2024
    India P1 A L2 23 City 2024
    India P1 A L2 43 SriBank 2024
    India P2 B L2 18 HDFC 2024
    India P2 B L2 68 SriBank 2024
    USA P1 A L1 30 BOA 2024
    USA P1 A L2 35 City 2024
    USA P2 B L1 44 SriBank 2024
    USA P2 B L2 95 HDFC 2024

     

    In the Qlike Sense a Pivot table, dimension rows have Region, Source and Industry. Column has Year and Product Dimensions.
    Please help me to create a measure expression to get the Rank for the 'SriBank' in the BankName table when the 'SriBank' is compared with all other values in the BankName column, and comparing is based on the Sum of Fee. The Pivot table cell values would be the Rank of 'SriBank' by Rows and Column dimensions and Total aggregated by all the columns. 

    Below is the expected pivot output

            Year Product      
          2023 2024
    Region Source Industry 2023 Total P1 P2 2024 Total P1 P2
    Global     2 0 1 1 3 2
    India
    India Total   4     1    
    A Total     0 2 1 1  
      L1            
      L2         1  
    B Total   2   2 1   1
    B L1 1   1      
      L2           2
    USA
    USA Total   1     2    
    A Total              
    A L1            
      L2            
    B Total   1   1 2 2 2
    B L1 1   1     1
      L2            
    Show Less
  • forum

    Installing and Upgrading

    Runtime log file "\log\tesb.log" never updated

    Hello, I have a Talend runtime that seems to be working correctly. However, the log file tesb.log has not been updated for a month now. Could you ple... Show More

    Hello,

    I have a Talend runtime that seems to be working correctly. However, the log file tesb.log has not been updated for a month now.

    Could you please tell me what I need to check? Additionally, I have restarted it, but it doesn't change anything. Thank you.

    Regards.

    Show Less
  • forum

    New to Qlik Analytics

    Null Handling in Data Loading Script

    Hi All,I have a date field Created_On at source. From source to QVD we are loading as it. Few records are NULL or Empty in Created_On. We need to impl... Show More

    Hi All,

    I have a date field Created_On at source. From source to QVD we are loading as it. Few records are NULL or Empty in Created_On. We need to implement such a logic so that Null fields will be populated as "Empty". Like below:

    if (Created_On = Null)

    then ("Empty")

    else

    (Created_On)

    Please suggest.

    Thanks in advance for your help.

    Sarif

    Show Less
  • forum

    App Development

    Error in Excel Add-Ins

    Hi there, I have followed this instruction (https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/excel-add-in-install... Show More

    Hi there,

    I have followed this instruction (https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/excel-add-in-install.htm) , however, I am getting the following error after implementing excel add-ins installation.

    sheehab_russel_1-1712203388480.png

     

     

    Show Less
  • forum

    Integration, Extension & APIs

    Extension sn-layout-container disappeared after installation of Patch 10 May 202...

    Hello,I just noted the above extension is gone from QMC after installation of Patch 10 May 2024 version.I also tried to manually install the extension... Show More

    Hello,
    I just noted the above extension is gone from QMC after installation of Patch 10 May 2024 version.
    I also tried to manually install the extension from the zip file but it gives me an error.
    Then I tried to do a repair of Qlik Sense Object Bundles but with no success.
    Finally I removed the Patch 10 to get the extension available again in QMC.
    I hope it will be fixed asap.
    Best Regards

    @Bastien_Laugiero  @Sebastian_Linser  @ToniKautto  @Michael_Tarallo 

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

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

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!