Line graph to show dynamic date comparison

[PM_QlikDev]

Hi All,

I have a requirement to show daily hourly order counts for dynamic date comparison.

By Default the chart should show data for latest Order Date,previous and a weekbefore,and when the user then selects any OrderDate from filter,then the chart should get updated for current selection date (CSD),CSD-1 and CSD-7 in a line graph with separate line for each measure.

For eg. Suppose Latest Order Date in a dataset is 27/12/2019 ,when a user opens the report he should see line graph showing 3 separate lines for 27/12/2019,26/12/2019,20/12/2019., and when he selects any date suppose 11/01/2019 then the chart should be updated to counts for 11/01/2019,10/01/2019,04/01/2019.

I have managed to fetch the count for max or current selected date using exp and not fetching data for -1 and -7 dates:

count({$<Order_Date={"$(=Date(Max($(v_Order_Date))))"}>} distinct OrderId)

where v_Order_Date= Date(floor(record_date),'DD/MM/YYYY') -----in order to fetch unique records for dates

I have tried everything from my end.Any sort of help on this would be highly appreciated.

PFA the expected line graph.

[Brett_Bleess]

Try the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

If you need to search further in this area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett