Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jlampard40
Contributor III
Contributor III

Set Analysis for calculating today's date

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

Labels (3)
1 Reply
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.