Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jlampard40
Contributor III
Contributor III

Using today () within a grouping set analysis

Hi guys - I have the following set analysis, which are now working well thanks to Sunny!

=Count({<[WBR_Stat_Date] = {"$(=Date(Today()))"}>} [WBR_Event_Key])  - for calculating number of clients currently waiting

=Num(Median({$<[WBR_Stat_Date]={"$(=Date(Today(),'DD/MM/YYYY'))"}>} RangeSum([WBR_Event_Date], -[WBR_Clock_Reset_Date])),'#,###') - for calculating the median number of days clients have been waiting for, as of today's report date

I now have the following formula:

=Num(Count(if([WBR_Event_Date]-[WBR_Clock_Reset_Date]<=14,'0-14 days'))/
Count([WBR_Event_Key]),'#.#%')

This needs to calculate the % of clients who are seen within 14 days based on the [WBR_Event_Date]-[WBR_Clock_Reset_Date] part of the formula - but I need this to only show the % as of today's report date.  So, again using the function today() to isolate my calculation to just today's report!

Appreciate all your help!

Rgds

 

0 Replies