topic Re: Max value in Straight table in QlikView

Max value in Straight table

Anonymous — Wed, 14 Oct 2015 05:54:43 GMT

I have a requirement where I have to display the Max of Sum of Amount spent in a straight table.

In the above case both A and C have 1000 and 1000 is the max.

Have given Name as dimension.

Can anyone help me on Expression please.

sunny_talwar — Wed, 14 Oct 2015 05:59:00 GMT

Expression can be this:

If(Sum(Amount) = Max(TOTAL Aggr(Sum(Amount), Name)), Sum(Amount))

Wed, 14 Oct 2015 06:03:53 GMT

Hi Koushik,

Below two expressions should work fine:

Max(aggr(Sum(Amount),Name))

FirstSortedValue( Name , -Amount )

Thanks,

Anonymous — Wed, 14 Oct 2015 06:05:27 GMT

Thanks a lot Sunny.

sunny_talwar — Wed, 14 Oct 2015 06:07:03 GMT

No problem

I am glad I was able to help.

Best,

Sunny