Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator
Creator

Two different date dimensions in Combo chart Qliksense for Comparative Analysis

Hi,

I have a data as show below

Process  Date  Run Time
Test Process 3-Dec-23 60
Test Process 4-Dec-23 50
Test Process 5-Dec-23 40
Test Process 6-Dec-23 50
Test Process 7-Dec-23 60
Test Process 8-Dec-23 10
Test Process 9-Dec-23 5
Test Process 5-Nov-23 50
Test Process 6-Nov-23 40
Test Process 7-Nov-23 30
Test Process 8-Nov-23 40
Test Process 9-Nov-23 50
Test Process 10-Nov-23 30
Test Process 11-Nov-23 25

 

Required Output is 

Process Source Date Target Date Source Run Time Target Run Time
Test Process 3-Dec-23 5-Nov-23 60 50
Test Process 4-Dec-23 6-Nov-23 50 40
Test Process 5-Dec-23 7-Nov-23 40 30
Test Process 6-Dec-23 8-Nov-23 50 40
Test Process 7-Dec-23 9-Nov-23 60 50
Test Process 8-Dec-23 10-Nov-23 10 30
Test Process 9-Dec-23 11-Nov-23 5 25

 

the mapping or the logic should be 1st week of current month = 1st week of last month

either a variable logic to manually select the  Source Data from calendar  and Target Data from other calendar date {using alernate states} 
or 
Any help or logic to get this in LINE chart

I actually want to create a chart as shown below

SK28_0-1703077758291.png

 

two date ranges in X-axis and those should be selected dynamically , so that they can see the Comparision of Process

Can anyone help me on this logic how to build

NOTE ONLY LIKE ABOVE  LINE CHART with primary & secondary axis BUT NEED IDEAS TO VIZUALLY REPRESENT THEM using QLIK charts 


EVEN VIZLIB library charts will also helps, Appreciate your help

1 Solution

Accepted Solutions
jochem_zw
Partner Ambassador
Partner Ambassador

 

Think this is what you need, result:

jochem_zw_1-1703149239993.png

 

 

jochem_zw_0-1703149212667.png

 

 

View solution in original post

5 Replies
jochem_zw
Partner Ambassador
Partner Ambassador

 

Think this is what you need, result:

jochem_zw_1-1703149239993.png

 

 

jochem_zw_0-1703149212667.png

 

 

SK28
Creator
Creator
Author

Thanks, Appreciate for your response @jochem_zw 

 

Here using the output of the above table I want to build the chart as shown above...!! 

 

and My question here is can we Pass Dynamically the date values using calendar object into The expression 

 

Like if User selects Date range = 1st week of last month to compare it with = 1st week of current month [December]

 

or if they selects 2nd week of current month and 2nd week of previous month

 

Can't we pass these date ranges dynamically into the chart expression?

 

the output should like above chart..

 

User has to select process then date range... two date ranges..! 

 

Those date range has to pass into the chart x-axis and into the measure expression

 

 

to filter out the data dynamically? and display above chart 

jochem_zw
Partner Ambassador
Partner Ambassador

Maybe not exactly what you want, but it is doing the trick: 

jochem_zw_0-1703152740410.png

 

SK28
Creator
Creator
Author

Oh Perfect @jochem_zw How did you got date range both source and target in X-Axis? 

 

and can you explain me Please how did you passed date values in the chart?

 

jochem_zw
Partner Ambassador
Partner Ambassador

Here is the APP, maybe it is useful. On the X-Axis there is however only 1 date label visible, but the graph is exact showing what you want. 2 different labels is not possible like in your example.