topic Re: Maximum count within a date range in QlikView

Maximum count within a date range

jlampard40 — Sat, 16 Nov 2024 01:32:26 GMT

Hi guys - I have a range of data (see attached sample) and I would like to identify the maximum value relating to the whichever date this occurs on (WBR_Stat_Date) in the data. Also the minimum.

I'd also like to (in a separate column in my table) state the date itself which corresponds to the Max and Min accordingly. Can you guide me please - many thanks in advance.

🐵

Re: Maximum count within a date range

jlampard40 — Fri, 10 Jan 2020 13:48:52 GMT

MIN Value should relate to 09/01/2019 in sample data guys, sorry - not 02/01/2019. My apologies.

Re: Maximum count within a date range

Kushal_Chawda — Fri, 10 Jan 2020 14:48:40 GMT

how is the expected output?

Re: Maximum count within a date range

Kushal_Chawda — Fri, 10 Jan 2020 15:13:19 GMT

Create straight table

Dimension - WBR_Stat_Date Expression - 1) Count of Key =Count(WBR_Event_Key) 2) Min/Max Value =if(WBR_Stat_Date = FirstSortedValue( total WBR_Stat_Date, -aggr(Count(WBR_Event_Key),WBR_Stat_Date)), 'Max Value: '& WBR_Stat_Date, if(WBR_Stat_Date = FirstSortedValue( total WBR_Stat_Date, aggr(Count(WBR_Event_Key),WBR_Stat_Date)), 'Min Value: '& WBR_Stat_Date ))

Re: Maximum count within a date range

Brett_Bleess — Mon, 10 Feb 2020 21:56:00 GMT

If Kush's post helped, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit for the help and to confirm to other Members that it did work for you. If you need further help, please leave an update, as otherwise folks are unlikely to add additional ideas, and if you figured out something else, consider posting that and then mark that as the solution.

Regards,
Brett