topic Month Wise max data in QlikView

Month Wise max data

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys

I need month wise max data, sample data is shared below

output:

trying with expression but is it now working : SUM(AGGR(MAX(SUM(RUN)),MONTH,PLAYER))

tresB — Sat, 20 Oct 2018 11:21:17 GMT

Straight table

Dim : Month

Exp 1 (Player) : FirstSortedValue( distinct Player, -Run)

Exp 2 (Run) : Max(Run)

shreya_nadkarni — Mon, 22 Oct 2018 03:16:08 GMT

Wanted to know for this scenario if there are two dimensions Player and Month.

How can we write 1 expression in order to get the output.is it possible? Thanks

shiveshsingh — Mon, 22 Oct 2018 06:23:09 GMT

Thanks tresesco, Can we build expression using AGGR function?

tresB — Mon, 29 Oct 2018 09:07:51 GMT

You can. Is there any specific reason why you would like to use aggr() here? In general, thumb rule is - avoid using aggr() wherever you can.