Qlik Community Contest

Hi,

I have a data table from a car rental company. The table contains around 60 million records showing the status of each vehicle on each day (not every vehicle appears every day).

I'm trying to add a flag field that marks the first occurrence of each vehicle with a 1.

I tried doing this using Min(Date), and also by sorting and using Previous(). The result is correct, but the load time is very long (over an hour).

Are there any other ways to add this flag without such a long load time?

Thanks!

Share with the rest of the group what brought you to this group.  What excites you most about being part of this community that supports women in data driven roles?

Over the past year the Women Who Qlik initiative has grown in size. To catch up on what has been happening and to learn more about the movement check out the links below:

Women Who Qlik Linkedin Live -Learn about this group of trailblazing women in our Qlik Luminary and Qlik Educator Ambassadors communities - past and present. Hear their personal stories of how they got into data careers, insights around data trends, and advice for allies and women exploring careers in STEM.

The Data Mix - Season 3 Episode 8 -Women Who Qlik

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! 

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.

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!

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)

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.

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.

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