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: 
  • 251,805 members
  • 5,103 online
  • 2,033,953 posts
  • 153,137 Solutions
Announcements
Qlik Launches Open Lakehouse and advanced agentic AI experience in Qlik Answers! | LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Women Who Qlik

    Welcome to the Women Who Qlik Group!

    This amazing initiative started in Lund at the Luminary Meetup but has grown in strength over the last year.   The movement aims at celebrating and em... Show More

    This amazing initiative started in Lund at the Luminary Meetup but has grown in strength over the last year.  

    The movement aims at celebrating and empowering women in data-driven roles, who leverage data to drive meaningful business outcomes. It focuses on EmpowHerment, amplifying the voices of women in technology and creating a safe space so women can feel comfortable being their authentic self. 

    Through events, mentorship, and storytelling, Women Who Qlik highlights the achievements of women in technology, encourages networking, and promotes diversity within the field of data. 

    We are so glad you are here! 

    Ps: Keep a look out for the exciting things happening with this initiative as you will be the first to know! 

    Show Less
  • forum

    Visualization and Usability

    How to show two week interval instead of daily on line chart?

    Hi, I've a line chart as below. Can you explain to me please how to show two week interval instead of daily on line chart? It should be showed as 02.0... Show More

    Hi,

    I've a line chart as below. Can you explain to me please how to show two week interval instead of daily on line chart? It should be showed as 02.01.2025, 16.01.2025 and soon..Many thanks.

    scr1.PNG

    Show Less
  • forum

    Application Automation

    Qlik Cloud Reload Automation Every 'x' Minutes – Performance & Quota Concerns

    Hi Community,I have a requirement to reload Qlik Cloud applications (an Extract app and a UI app) every 5 minutes, continuously 24/7. Since the native... Show More

    Hi Community,

    I have a requirement to reload Qlik Cloud applications (an Extract app and a UI app) every 5 minutes, continuously 24/7. Since the native Qlik Cloud scheduler only supports hourly intervals, I've implemented a solution using Qlik Application Automation with a "Task Chain with a Condition(Task chain with a condition)." This setup is currently working fine, as the data volume is relatively low (~100K records).

    However, I want to validate whether this approach is scalable and aligned with best practices.

    Here’s a breakdown of the reload frequency:

    • 12 reloads per hour

    • 288 reloads per day

    • ~8,640 reloads per month (assuming 30 days)

    My questions are:

    1. Is using Qlik Application Automation with a Task chain with a condition  every 5 minutes a recommended and scalable approach?

    2. Will this continuous 5-minute interval reload raise any concerns regarding Qlik Cloud automation quota limits or system performance over time?

    Appreciate any insights or recommendations from those who have implemented a similar high-frequency reload strategy.

    Thanks!

    Show Less
  • forum

    Visualization and Usability

    Job Count for previous FYYear in Pivot Table

    Hi All,I have this Pivot Table, where the dimensions are 'Region' and 'FYYear', which is a Financial Year field from a Master Calendar. The table curr... Show More

    Hi All,

    I have this Pivot Table, where the dimensions are 'Region' and 'FYYear', which is a Financial Year field from a Master Calendar. The table currently has one measure - 'Jobs', which is just a simple job count. Count(distinct RegionJobNumber)

    akelleway_0-1747997620513.png

    But I am struggling with getting the same measure working for the previous FYYear. I am currently sat on this expression: Count({$<FYYear={"$(=max(FYYear)-1)"}>}distinct RegionJobNumber) but as you can see from the attached image, it is not working. The data itself goes back to 2015, but the FYYear dimension is filtered to >= 2022, so every column has the data required for this to work.

    For now I am just trying to get this working as a standalone column measure, to check that the correct output is being produced. But eventually this will go into another measure, which will compare the Job Count (FYYear) to Job Count (FYYear-1) and then aggregate them by another field [CUSTOMER GROUP] to return the number of Customer Groups who had fewer jobs than the previous FYYear.

    Any suggestions would be much appreciated.

    Show Less
  • forum

    Reporting Service & Alerting

    PPT Generation using Automation - Filtering not Working

    I'm using automation to generate a PowerPoint (PPT) report from my Qlik sheets. Although I apply filters within the automation workflow, the final PPT... Show More

    I'm using automation to generate a PowerPoint (PPT) report from my Qlik sheets. Although I apply filters within the automation workflow, the final PPT report is generated without applying those filters it shows the unfiltered data instead.

    Has anyone faced this issue or knows what might be going wrong? I'm looking for a way to ensure that the filters applied in automation are reflected correctly in the generated PPT.

    Show Less
  • forum

    Qlik Replicate

    Generate DDL(transformed) for Data Migration

    I am new to Qlik Replicate and trying to understand some of the functionalities. Our Source is Informix and Target is Azure SQL.  I want to generate t... Show More

    I am new to Qlik Replicate and trying to understand some of the functionalities. Our Source is Informix and Target is Azure SQL. 

    I want to generate the (transformed) DDL which will be used to create objects in SQL Server(Tables/PK/FK/Indexes). Does the tool allow it using some API? Can you please let me know how to do it, if the tool allows?

    Thanks.

    Show Less
  • forum

    Reporting Service & Alerting

    hoe to eliminate empty table when using Levels

    Hi Allin my excel report i'm using Country Field as a Level to break down into separated sheet for each Country.some of the countries does not contain... Show More

    Hi All

    in my excel report i'm using Country Field as a Level to break down into separated sheet for each Country.

    some of the countries does not contain any data in the specific table and they not appear in the app, but in the report all countries values appear in the report with blank sheet.

    any idea how to eliminate the empty sheets ?

    advanced thanks

    Show Less
  • forum

    Qlik NPrinting

    Conditionally hide HTML table row

    I've created an NPrinting HTML report that contains an HTML table based on a straight table in Qlik Sense. It works fine. Now I would like to hide one... Show More

    I've created an NPrinting HTML report that contains an HTML table based on a straight table in Qlik Sense. It works fine. Now I would like to hide one column in NPrinting based on a condition. I created a formula that returns an HTML row if the condition is met, else an empty string:

    =If(Include='bh', '<td style="border-collapse:collapse;border: 1px solid;text-align: left;">%%Site%%</td>','')

    But the result, in an email, is all messed up.

    Is this possible in an HTML report or do I need to use PixelPerfect instead?

    Note that I'm on NPrinting Feb 2024 SR3 but that's not an option in the dropdown menu.

    Show Less
  • forum

    Visualization and Usability

    Qlik Sense Desktop stuck with "Initializing Add data" after pressing the add dat...

    Hi, I am having the above issue on a fresh installed Qlik Sense Desktop version.Installed the November 2019 Qlik Sense Desktop version on up to date w... Show More

    Hi, 

    I am having the above issue on a fresh installed Qlik Sense Desktop version.

    Udklip.PNG

    1. Installed the November 2019 Qlik Sense Desktop version on up to date windows 10 Dell laptop.
    2. Created an App and opened it
    3. Pushed the area to add data
    4. A circle appears with the following text below "Initializing Add data" 
    5. Noting mores happens

    What to do? 

    I tried to repair, run as admin but nothing works. 

    Running the cloud version seems to work fine.

     

     

    Show Less
  • forum

    Qlik Replicate

    Dear Qlik Support Team, We are currently planning to deploy Qlik Replicate on a...

    Dear Qlik Support Team, We are currently planning to deploy Qlik Replicate on a Linux platform and intend to use NAS as the shared storage solution. W... Show More

    Dear Qlik Support Team,

    We are currently planning to deploy Qlik Replicate on a Linux platform and intend to use NAS as the shared storage solution. We would like to inquire about Qlik’s official support and any potential risks or limitations for the following two NFS-related scenarios:

    1. Virtual machines using NFS-backed virtual disks:
    Qlik Replicate is running within a virtual machine (e.g., VMware), where the VM's virtual disk (e.g., VMDK) is stored on a backend NFS file system via the hypervisor or other mechanisms. The VM itself accesses the storage as a block device. Could you please confirm if this architecture is officially supported by Qlik? Are there any potential risks or recommended configurations for this setup?

    2. Direct NFS mount within the VM for Qlik Replicate storage:
    Within the VM’s operating system, an NFS path is directly mounted and used by Qlik Replicate to store its working directory, task metadata, replication state files, log files, and internal repository. We understand this may introduce I/O performance latency, but we would like to further clarify whether this configuration could cause file locking issues, lead to data consistency risks during HA or failover scenarios, or if there are any additional use cases that Qlik specifically advises against. If any related recommendations or official technical documentation are available, we would appreciate it if you could kindly share them with us.

    Thank you for your assistance.

    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!