topic Re: Calculating average per week Set Analysis in QlikView

Calculating average per week Set Analysis

jlampard40 — Sat, 16 Nov 2024 02:20:24 GMT

Hi guys

I have set analysis which calculates how many clients are currently waiting, based on today's date:

=Count({<[WBR_Stat_Date] = {"$(=Date(Today()))"}>} [WBR_Event_Key])

This works great! However, what set analysis do I need to use to calculate the average number of clients waiting since records began in my company (3 months ago!) The field [WBR_Stat_Date] is what signifies the date of each stat. Many thanks.

Re: Calculating average per week Set Analysis

rubenmarin — Tue, 01 Oct 2019 19:13:35 GMT

Hi, maybe with?

=Count([WBR_Event_Key])/Count(Distinct [WBR_Stat_Date])

// Counting all WBR_Event_Key (is this what says that clients are waiting?) divided by different dates

or:

=Count([WBR_Event_Key])/(Max([WBR_Stat_Date])-Min([WBR_Stat_Date]))

This version counts all days between the lower and higher dates

Re: Calculating average per week Set Analysis

jlampard40 — Wed, 02 Oct 2019 07:13:03 GMT

Thanks so much!