Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 241,529 members
  • 5,462 online
  • 2,024,327 posts
  • 152,254 Solutions
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY

Welcome to Qlik Community

Recent Discussions

  • No Boards Found
  • forum

    Connectivity & Data Prep

    Tiempo de carga SQL Server - Qlik Cloud

    Tengo una conexión a SQL en Qlik Cloud, la tabla resultante tiene aproximadamente 6 millones de datos. Normalmente tardaba 1 hora en realizar la recar... Show More

    Tengo una conexión a SQL en Qlik Cloud, la tabla resultante tiene aproximadamente 6 millones de datos. Normalmente tardaba 1 hora en realizar la recarga, de un momento a otro el tiempo de recarga aumento al punto de que el script de carga aborta por exceder el tiempo máximo (3 horas). Hablé con los dueños de la base de datos y ellos me indican que no se realizó ninguna modificación en esta. Por otro lado, al realizar esta misma conexión pero en Qlik Sense On Premise la recarga de datos se completa satisfactoriamente. 

    ¿A qué se puede deber esto?

    Show Less
  • forum

    Qlik Replicate

    Filtering NULL Values in Qlik Replicate

    Hi Team,I want to filter out records as per the below condition:The cardnumber from source which has null values should not be pushed to target. Only ... Show More

    Hi Team,

    I want to filter out records as per the below condition:

    The cardnumber from source which has null values should not be pushed to target. Only cardnumber which holds field values should be pushed. How can I achieve this.

    FIlter.jpg

    Show Less
  • forum

    Japan

    要約統計量を並べたテーブルの作成

    お世話になります。Qlik Senseのクラウド版を使用しております。添付のようなテーブルを作成しようと考えていますが、Qlik Senseでは可能なものでしょうか。可能な場合、どの機能を使えばよろしいでしょうか。(シート→チャート→テーブルで行けるものでしょうか。)ご教示いただけますと幸いです。(... Show More

    お世話になります。
    Qlik Senseのクラウド版を使用しております。
    添付のようなテーブルを作成しようと考えていますが、Qlik Senseでは可能なものでしょうか。
    可能な場合、どの機能を使えばよろしいでしょうか。
    (シート→チャート→テーブルで行けるものでしょうか。)
    ご教示いただけますと幸いです。
    (必要な項目が載っていれば、テーブルの形は多少崩れても構いません。)

    恐れ入りますが、よろしくお願いいたします。

     

    20250113_021929.png

    Show Less
  • forum

    New to Qlik Analytics

    Automatic Loading of Excel Files form a folder connection through Script

    Hi. I have a folder connected to my Qlik Sense Enterprise cloud where i have placed multiple excel files. My excel files contain multiple sheets with ... Show More

    Hi. I have a folder connected to my Qlik Sense Enterprise cloud where i have placed multiple excel files. My excel files contain multiple sheets with each sheet has different data and different number of columns. The problem arises when i try to upload them automatically using the script. It only loads the first sheet and gives an error in loading other sheets. what should be included in script for load multiple sheets from an excel file?

    Currently the load script which is working fine to load single sheet file is below:

    SET vFolderPath = 'lib://....*...*...';

    FOR Each vFile IN FileList('$(vFolderPath)\*.xlsx')
    TRACE Loading File: $(vFile);

    1. LOAD *
      FROM [$(vFile)] (ooxml, embedded labels, header is 1 lines);
      NEXT vFile
    Show Less
  • forum

    Qlik Application Automation

    How to get Space -> Apps -> Sheets information into a QVD file using single Auto...

    I am trying to get the details of all the space, apps and the sheets in each app into a QVD file to create an app on this. Could anyone suggest how to... Show More

    I am trying to get the details of all the space, apps and the sheets in each app into a QVD file to create an app on this. Could anyone suggest how to achieve this in Qlik Sense SaaS version please.?

    Ex. I need to create a table like below

    SpaceName     AppName    SheetName                             SheetType

    Dev                  Test              Space_App_Sheets                Public

    Prod                 Test1            Demo                                      Private

    Show Less
  • forum

    New to Qlik Analytics

    Remove the entire row when measure returns 0

    Hi All, I need to remove the entire row when something returns null. While working with dimension, unchecking the include null values works perfectly,... Show More

    Hi All,

    I need to remove the entire row when something returns null. While working with dimension, unchecking the include null values works perfectly, The similar action I need to perform in a measure.

    This is the final table that I am seeing now

    APM NUMBER PRODUCT Fiscal year period Total cost Product Specific sum
    123 Apple 2020001 3 $3
    123 Apple 2020002 0 -
    123 Apple 2020003 3 $6
    456 Apple 2020001 4 $10
    456 Apple 2020002 5 $15
    456 Apple 2020003 6 $21
    678 Apple 2020001 1 $27
    678 Apple 2020002 0 -
    678 Apple 2020003 3 $30
    910 Banana 2020001 1 $1
    910 Banana 2020002 2 $3

    Here the total cost column is a sum(field 1 +field2) so it always returns 0 if there is sum(null,0), While calculating cumulative cost the calculations are performed rightly but this issue happens. 

    Now I want to remove the entire row that returns - ,how to do that?

    I tried the combination of if and not isnull but those return the same table.

    Has anyone faced this issue? Please help me resolving this

     

    Regards,

    Keer

    Show Less
  • forum

    Move to SaaS

    App Active Status

    Hello ExpertsI have a client inquiry concerning their Qlik Sense SaaS environment where we've recently deployed 20 dashboards. These dashboards are st... Show More

    Hello Experts

    I have a client inquiry concerning their Qlik Sense SaaS environment where we've recently deployed 20 dashboards. These dashboards are static, with data loaded only once at deployment and no subsequent refreshes planned.

    Could you recommend a tool or method to monitor the health of these dashboards daily in the Qlik Sense SaaS environment ?

    Basically I wanted to check if the 20 dashboard is active and Its up and running.

    I am not interested in checking the RAM usage or reloads or numbers of Users using dashboard or Synthetic keys. I wanted to check only the status of the dashboard if it is active and up running on Qlik Saas.

    Based on the above requirement which tool can perform this in Qlik.

    Thank you!

    Show Less
  • forum

    App Development

    Qlik Sense Table chart with one of the columns split up in multiple rows

    Hi ev'ryone, I'm trying to build a table in Qlik Sense that has 26 columns (each bound to an ID) plus two more column (Year + Measure) that shall have... Show More

    Hi ev'ryone,

    I'm trying to build a table in Qlik Sense that has 26 columns (each bound to an ID) plus two more column (Year + Measure) that shall have multiple rows (one for each year). So what I want is one row for the ID and the 25 following columns and then that row splitting into one row for each year and the value/measure for the respective year.

    Somehow it seems that Qlik Sense won't let me create such a table.
    In Qlikview this was no problem (see the screenshot to have an idea how it shall be)

    Screenshot 2025-01-22 114404.png

    Can anyone help, please?
    Thank you in advance 🙂

    Show Less
  • forum

    New to Qlik Analytics

    Cumulative Sum based on Aggr()

    Hi All, I have a sample data as  APM NUMBER PRODUCT Fiscal year period Total cost   123 Apple 2020001 1   123 Apple 2020002 2   123 Apple 202... Show More

    Hi All,

    I have a sample data as 

    APM NUMBER PRODUCT Fiscal year period Total cost  
    123 Apple 2020001 1  
    123 Apple 2020002 2  
    123 Apple 2020003 3  
    456 Apple 2020001 4  
    456 Apple 2020002 5  
    456 Apple 2020003 6  
    678 Apple 2020001 1  
    678 Apple 2020002 2  
    678 Apple 2020003 3  
    910 Banana 2020001 1  
    910 Banana 2020002 2  

     

    Here the cumulative sum must restart for each new product, but should not change even if the products' APM number is changed(the sample output is given at last). I performed the cumulative sum as 
    NUM(
    Aggr(
    RangeSum(
    Above(
    Sum({1}{$}[Total cost]),
    0,
    RowNo(Total)
    )
    ),
    PRODUCT,[APM NUMBER]
    ),
    '$#,##0'
    )

     

    I got the result as 

    Keerthi1234_0-1737525575809.png

    It works but it gives null values because of aggregation . I need my resulting table as 

    Here I need the Product Specific cumulative Sum as required

    APM NUMBER PRODUCT Fiscal year period Total cost Product Specific sum
    123 Apple 2020001 1 $1
    123 Apple 2020002 2 $3
    123 Apple 2020003 3 $6
    456 Apple 2020001 4 $10
    456 Apple 2020002 5 $15
    456 Apple 2020003 6 $21
    678 Apple 2020001 1 $27
    678 Apple 2020002 2 $29
    678 Apple 2020003 3 $32
    910 Banana 2020001 1 $1
    910 Banana 2020002 2 $3

    Has someone face this issue, Please help me understanding this.

     

    Regards,

    Keer

    Show Less
  • forum

    Move to SaaS

    Data Types issue when compared to Enterprise and SaaS Cloud

    Hi All, We are tried to add one of the field that has mixed data types and when it comes to enterprise the the text is showing ion the left alignment ... Show More

    Hi All,

    We are tried to add one of the field that has mixed data types and when it comes to enterprise the the text is showing ion the left alignment and num is right alignment which is an expected scenario but when we are trying to load same set of data on the Qlik cloud its treated everything as a text and showing as left alignment.

     

    is there a way to fix this issue without using dual function?

    Regards,

    Raju

     

    Show Less
Weekly 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.

Location and Language Groups

Choose a Group

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

Collaborate

Blogs

Community News

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