topic Re: RangeSum - really stuck...! in QlikView

RangeSum - really stuck...!

jlampard40 — Sat, 16 Nov 2024 02:18:02 GMT

I have a set analysis formula which is working really well, to give me an overall number of clients currently waiting for a surgical procedure:

=Count({$<[WBR_Stat_Date]={"$(=Date(Today(),'DD/MM/YYYY'))"}>} RangeSum([WBR_Event_Date], -[WBR_Clock_Reset_Date]))

[WBR_Stat_Date] = the current date of the report, and I always need this to be today's date, which this formula is achieving.

[WBR_Event_Date]-(WBR_Clock_Reset_Date] - is what I need to calculate (one minus the other) to give me days waiting. Again, this formula does this well.

What I need to do now, is to only count when the days waiting is over 14 days. Can anyone please advise how I can achieve this, within the current set analysis I have? Many thanks.

Re: RangeSum - really stuck...!

qliksus — Tue, 08 Oct 2019 05:40:15 GMT

Not sure why you use rangesum for this requirement . why cant you try this

=Count({$<[WBR_Stat_Date]={"$(=Date(Today(),'DD/MM/YYYY'))"} cleint ) * purgechar( [WBR_Event_Date]-[WBR_Clock_Reset_Date])>14 ,'-')

Re: RangeSum - really stuck...!

Brett_Bleess — Mon, 14 Oct 2019 12:41:28 GMT

James, did the other post take care of your requirement, or are you still stuck? If things worked, please be sure to circle back to use the Accept as Solution button on the posters comment to give them credit and let others know that did meet your requirement. If you are still working on things, leave an update.

The only other thing I can offer here is a Design Blog post that may provide some further insights potentially.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett