Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
24_02_SRR
Contributor III
Contributor III
‎2024-03-04 02:07 AM

combo chart with different dimension

Hi All,

We need to built one combo chart with various dimension and current year month Vs Last year month comparison.

Kindly refer the below image for reference.

24_02_SRR_0-1709535923131.png

Anyone can suggest, how to achieve this in Qlik Sense. 

161 Views
1 Reply
pravinboniface
Creator II
Creator II
‎2024-03-06 12:04 AM

I would load all the distinct dates into another table and re-classify them as 2018, 2019, etc, 2024 YTD, Jan 2024 etc.

Somewhat like how it's described below:

Assuming that the date column for your chart is named YYYYMM, I would extract all of the distinct values into another table called X-AXIS with two columns, YYYYMM and NewDateColumn.

For any value in 2018 in YYYYMM, I would set NewDateColumn to 2018

For any value in 2019 in YYYYMM, I would set NewDateColumn to 2019

etc

For any value in 2024 in YYYYMM, I would set NewDateColumn to 2024YTD

I would again load 202401 in YYYYMM and set NewDateColumn to Jan 2024

I would again load 202402 in YYYYMM and set NewDateColumn to Jan 2024

etc

Now, I would use the NewDateColumn as the dimension in the chart

If you use autocalendar, it will make it even more easier to implement this logic in the load script.

124 Views