topic Re: Max value from month in QlikView

Max value from month

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

Hi,

in my table i have 1 dimension called month and in expression we have actual value for it.

but now in next column(Max Actual) i have to populate maximum value out of all months . so in my below table max actual column should give 92.4 for all months. as 92.4 is the highest value. how can i write can any one suggest me.

Re: Max value from month

sergio0592 — Wed, 29 Jan 2020 18:23:57 GMT

Hi,

Try with below formula. Should works

max(TOTAL Actual)

Re: Max value from month

dunnalahk123 — Thu, 30 Jan 2020 03:02:18 GMT

Thank You Sergio . it works