Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys - I've attached a sample Excel file i'm using, to try and show how many client's exams were requested on a date which is equal to today. So, in this example, based on today's date of 20/11/2019, I would like it to count all those instances where:
AD_Data is equal to 'Demand' only
AD_Request_Date is equal to today's data - so for today it would be 20/11/2019
Also, would like to show the average count of instances over the past 5 days using AD_Request_Date as the date reference.
We count using AD_Event_Key as this is a unique / distinct counting reference.
Thanks guys.
Rgds
James, best I have is the following Design Blog post that may be of some help:
https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511
There are some other Set Analysis posts in this area as well, here is the base URL in case you want to search further:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett