Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 253,964 members
  • 4,588 online
  • 2,035,763 posts
  • 153,304 Solutions
Announcements
Gartner® Magic Quadrant™: 15 YEARS A LEADER - GET THE REPORT

Welcome to Qlik Community

Recent Discussions

  • forum

    QlikView App Dev

    Showing Number of Nulls for Each Field

    I would like to create a table that lists every field, which has columns for the total number of nulls, the percentage of rows that have a null, etc. ... Show More

    I would like to create a table that lists every field, which has columns for the total number of nulls, the percentage of rows that have a null, etc. What is the best way to go about this? I have a pivot table that uses $Field as the dimension, but I am unsure how to count the null values in Qlikview.

    Show Less
  • forum

    Visualization and Usability

    Generate dates based on field with condition

    Hello Qlik community,   I am struggling a bit with a data transformation I need to perform. I have a table like this one start_date division servic... Show More

    Hello Qlik community,

     

    I am struggling a bit with a data transformation I need to perform.

    I have a table like this one

    start_date division service ID

    01/01/2025

    EMEA AAA AHEMA
    01/03/2025 APAC BBB AHEMA
    01/04/2025 EMEA CCC AHEMA
    01/01/2025 LAM DDD KILMA
    01/05/2025 NAM EEE KILMA

     

    What I need to get is this table below with a new field Period 

     

    start_date division service ID Period
    01/01/2025 EMEA AAA AHEMA

    202501

    01/01/2025 EMEA AAA AHEMA 202502
    01/03/2025 APAC BBB AHEMA 202503
    01/04/2025 EMEA CCC AHEMA 202504
    01/04/2025 EMEA CCC AHEMA 202505
    01/01/2025 LAM DDD KILMA 202501
    01/01/2025 LAM DDD KILMA 202502
    01/01/2025 LAM DDD KILMA 202503
    01/01/2025 LAM DDD KILMA 202504
    01/05/2025 NAM EEE KILMA 202505

     

    I've tried something like that but it is not working as it is ignoring the change of division/service

     

    LET vMaxDate =num(monthstart(today()));

    LOAD distinct

    start_date,
    division,
    service,
    DATE(MonthStart(start_date+ IterNo() - 1),'YYYYMM') AS Period,
    ID
    FROM [lib://AttachedFiles/Classeur1.xlsx]
    (ooxml, embedded labels, table is Feuil1)
    WHILE start_date+ IterNo() - 1 < $(vMaxDate);

     

     

     

    I am missing something here but can't figure it out.

    Thanks for any help !

     

     

    Show Less
  • forum

    Talend Cloud

    Which fans benefit the most from the IndiaMatch service?

    IndiaMatch would be favorable for fans who want to follow sports's up-to-the-second progressive updates but aren't always technologically able! You ca... Show More

    IndiaMatch would be favorable for fans who want to follow sports's up-to-the-second progressive updates but aren't always technologically able! You cant work, or commuting or millions of times access to match info I would be happy to be near customer onsite updates, mapping every ball from detailed accurate ball-by-ball coverage, with milestones and stats on all the notable moments. Fans can feel engaged with Team India's connectedness to a moment without it going up on a half-baked screen or on-demand media.

    Show Less
  • forum

    App Development

    what is the standard usage to test section with data reduction ?

    Hello,In Qlik Cloud, how can I test the Access section with scope reduction?Is it possible to simulate the display for a specific user? (I'd like to a... Show More

    Hello,

    In Qlik Cloud, how can I test the Access section with scope reduction?

    Is it possible to simulate the display for a specific user? 

    (I'd like to avoid app reload between each test)

    Regards

    Show Less
  • forum

    App Development

    Pivot table - Unable to sort multiple measures in QlikSense

    Hi Folks,Hope you're doing well !!I came across one of the requiremnet where we need to show all measures value in descending order in pivot table of ... Show More

    Hi Folks,

    Hope you're doing well !!

    I came across one of the requiremnet where we need to show all measures value in descending order in pivot table of qliksense.

    Is there a way to do customize sorting of pivot tables in Qlik sense so that measures should show in descending order, I have tried both sort by first measure and sort by expression but still lagging to get this.

    Karim_Khan_0-1750317811627.png

     

    Regards,

    KK

    Show Less
  • forum

    Management & Governance

    QMC and HUB not accessable after installation - only with localhost

    Hi guys, we have a very special problem for the dedectives among us 🙂We installed Qlik Sense Enterprise on a VM using the CNAME qlik-dev.ad.ourdomain... Show More

    Hi guys, we have a very special problem for the dedectives among us 🙂

    We installed Qlik Sense Enterprise on a VM using the CNAME qlik-dev.ad.ourdomain.de. Everything lookes fine after installation. Services are running under the service account. Ports are open, Qliks certificates are correct.

    When using localhost/qmc or hub, logged in with the service account, everything works fine but no authentication window appears.

    When using qlik-dev.ad.ourdomain.de/qmc or hub or even localhost in incognito mode the windows authentication window appers but after entering the correct user/password the attached ERR_UNEXPECTED appears.

    Has anyone of you experienced a problem like that?

    Kind regards, Andy

    Qlik Sense Enterprise on Windows 

    Show Less
  • forum

    App Development

    Skip Loading, Empty Field

    Morning All,I have the following table appearing on the preview page of my app. I've not deliberately generated this and it doesn't connect to my data... Show More

    Morning All,

    I have the following table appearing on the preview page of my app. I've not deliberately generated this and it doesn't connect to my data in any way. It also appears to not be causing any problems.

    Skip Loading Empty Field.JPG

    • Has anyone seen this behaviour before?
    • Does anyone have any ideas what's causing it and how to fix it?
    • Am I right in thinking that there's no negative impact? (other than unsightliness / confusion)

    The source is Snowflake. App is in Qlik Cloud Analytics.

    Thanks in advance.

    Show Less
  • forum

    App Development

    Unusual Expression Parsing with // (Comment) and Line Breaks in Qlik Sense SaaS ...

    Hello Qlik Community,I've encountered a very peculiar behavior with an expression in Qlik Sense SaaS that seems to defy standard parsing rules and mig... Show More

    Hello Qlik Community,

    I've encountered a very peculiar behavior with an expression in Qlik Sense SaaS that seems to defy standard parsing rules and might indicate a bug. I'm hoping to get some insight, confirmation, or a potential explanation for this.

    The Goal:

    I'm trying to calculate the sum of Revenue for a specific Period defined by a variable vMaxPeriod, using the TOTAL qualifier to get a grand total (disregarding chart dimensions).

    The Working Expression (Surprisingly):

    My expression only works when structured exactly like this, including the // (comment) characters and specific line breaks:

    Code snippet
     
    Sum({$<Period={$(vMaxPeriod)}>} //
        TOTAL [GL_Hub]
        Revenue)

    Key Observations for the Working Expression:

    1. The // (comment characters) are present on the line immediately after the closing curly brace of the set analysis (}).
    2. TOTAL [GL_Hub] and Revenue) are on separate lines, following the line with the // comment.

    The Problem: Expressions That Don't Work (and why they should according to documentation):

    If I remove the // comment, or if I consolidate TOTAL [GL_Hub] Revenue onto a single line after the set analysis, the expression breaks and returns an error.

    1. Removing // (should work if // were just a comment):

      Code snippet
       
      Sum({$<Period={$(vMaxPeriod)}>}
          TOTAL [GL_Hub]
          Revenue)
      • Result: Does not work. This suggests the // is serving a functional purpose beyond just being a comment.
    2. Consolidating TOTAL and Field on one line (standard recommended syntax):

      Code snippet
       
      Sum({$<Period={$(vMaxPeriod)}>} TOTAL [GL_Hub] Revenue)
      • Result: Does not work. This is particularly confusing, as this syntax (Sum({SetAnalysis} TOTAL Field)) is generally the recommended way to get a grand total with set analysis in Qlik Sense.

    My Environment:

    • Qlik Sense SaaS (Cloud)

    My Question to the Community:

    • Has anyone else experienced this kind of behavior where a // comment seems to be functionally required for an expression to parse correctly?
    • Is there a documented reason for // to act as a "soft line break" or continuation marker in this specific scenario?
    • Is this a known bug in Qlik Sense SaaS, or am I missing a fundamental parsing rule specific to my environment?

    I've verified that $(vMaxPeriod) resolves correctly to a valid period value and that [GL_Hub] Revenue is the correct field reference. The issue consistently lies with the presence/absence of // and the specific line breaks.

    Any insights or similar experiences would be greatly appreciated!

    Thank you,

    Will

     

    Show Less
  • forum

    Qlik NPrinting

    Columns in pivot table do not keep background color

    Hi! I have a straight table in QLik Sense and I built such table in QlikNprinting and then form it I wanted to built pivot table.I changed headers to ... Show More

    Hi! 

    I have a straight table in QLik Sense and I built such table in QlikNprinting and then form it I wanted to built pivot table.
    I changed headers to be blue but values columns does not keep that color:

    midnight1_0-1750423633763.png

    but when data is added:

    midnight1_1-1750423891847.png

    here are my settings:

    midnight1_2-1750423966217.png

    keep source format also turned off for columns.
    how can i make it work?

     

    Qlik NPrinting February 2024 SR3

    Version: 24.4.14.0

    Show Less
  • forum

    Management & Governance

    Deleting Logs

    Qlik Sense Enterprise on Windows Is it safe to delete logs from this folder C:\ProgramData\Qlik\Sense\Log\CapabilityService Both old and new.And why s... Show More

    Qlik Sense Enterprise on Windows 

    Is it safe to delete logs from this folder C:\ProgramData\Qlik\Sense\Log\CapabilityService 

    Both old and new.

    And why some logs are of 32 GBs 

    @Damien_V @Bastien_Laugiero 

    Show Less
Leaderboard

Customer Story

Optimizing Food Relief with Qlik

Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

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!