topic Re: Need help on using Max function in expression in QlikView

Need help on using Max function in expression

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

I have two fields in data Id and sales. I am trying to take sum of sales for maximum value of ID but it is giving me sum only for 1 maximum id value which is at the last. the expression I am using is as below:

Sum({$<id={"$(=max(id))"}>}sales)

Re: Need help on using Max function in expression

sunny_talwar — Fri, 02 Feb 2018 16:50:44 GMT

May be you need this

FirstSortedValue(Aggr(Sum(Sales), id), -id)

Re: Need help on using Max function in expression

devarasu07 — Fri, 02 Feb 2018 16:53:00 GMT

Hi,

method 1:

=FirstSortedValue(ID,-Sales)

method 2:

=max(aggr(sum(Sales),ID))

Re: Need help on using Max function in expression

vishsaggi — Fri, 02 Feb 2018 16:58:22 GMT

Also try this May be?

= Max(Aggr(Sum(Sales), Id))

Re: Need help on using Max function in expression

shiveshsingh — Sat, 03 Feb 2018 02:57:55 GMT

Max(aggr(sum(sales),ID))

Re: Need help on using Max function in expression

isingh30 — Sat, 03 Feb 2018 17:48:17 GMT

Please check the screenshots.

Let me know.

Thanks.