topic Re: show dimension for max value in QlikView

show dimension for max value

Sat, 20 Jun 2015 21:49:56 GMT

Hi,

I'm trying to show in a text object the field value for the corresponding max value of a calculation.

I'm calculating the total incoming values by TransactionHour, and want to show theTransactionHour that is the maximum.

I've tried variants of firstsortedvalue and max(aggr(sum())), but i can't seem to return theTransactionHour for the max value.

I know I've done this before, but maybe I've been staring at it too long

Richard

Re: show dimension for max value

swuehl — Sat, 20 Jun 2015 22:16:21 GMT

Try something like

=FirstSortedValue( TransactionHour, -aggr( sum(PC.IN), TransactionHour) )

Re: show dimension for max value

MarcoWedel — Sat, 20 Jun 2015 23:22:58 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

Re: show dimension for max value

Sun, 21 Jun 2015 00:01:48 GMT

Thanks,

That was it

=FirstSortedValue( TransactionHour, -aggr( sum(PC.IN), TransactionHour) )

It turns out that was one of the expressions I tried, but had inadvertently excluded the data source by filtering, so it was returning '-' and i thought my expression was wrong...Time to take a break!

Re: show dimension for max value

pratap6699 — Sun, 21 Jun 2015 19:37:34 GMT

=FirstSortedValue( TransactionHour, aggr( sum(PC.IN), TransactionHour) )-----it shows 1st fieldvalue means accesnding order 1st value

=FirstSortedValue( TransactionHour, -aggr( sum(PC.IN), TransactionHour) )-----it shows max fieldvalue means decesnding order 1st value

Re: show dimension for max value

Mon, 27 Feb 2017 12:25:58 GMT

Hi, how would make sure that this set analysis ignores all other TransactionHour selections?