Set Analysis for calculating today's date

jlampard40 — Sat, 16 Nov 2024 01:53:45 GMT

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

Re: Set Analysis for calculating today's date

Brett_Bleess — Wed, 04 Dec 2019 19:12:53 GMT

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

topic Re: Set Analysis for calculating today's date in QlikView

Set Analysis for calculating today's date

Re: Set Analysis for calculating today's date