Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Think this is what you need, result:
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
Maybe not exactly what you want, but it is doing the trick:
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?
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.