topic Re: Max value within a pivot table in QlikView

Max value within a pivot table

mohamed_ahid — Wed, 03 Sep 2014 14:31:56 GMT

Hi all,

suppose that we have a pivote table like this :

ID name V MaxE Min E

1 name1 24 3874 24

34 name2 398 3874 24

25 name3 293 3874 24

345 name4 872 3874 24
2 name5 873 3874 24

5 name6 3874 3874 24

V=sum (value of transactions ) for week 12 and 11 / sum (value of transactions ) for week 9 and 10

how can i get max of V and min of v in the same table( i will use them after that in an expression)

THX

maxgro — Wed, 03 Sep 2014 15:08:18 GMT

maybe (replace sum.... with your expression for V column)

max(total

aggr(

sum (value of transactions ) for week 12 and 11 / sum (value of transactions ) for week 9 and 10,

ID, name

)

MK_QSL — Wed, 03 Sep 2014 15:10:27 GMT

What are the dimension in this table?

You can get the max by

Max(Total Aggr(YourExpression,Dim1,Dim2....etc))

Anonymous — Wed, 03 Sep 2014 15:16:20 GMT

Try something like the below as expressions in your Pivot Table for MaxE and MinE :

Max( TOTAL aggr ( sum(V) , ID) )

Min ( TOTAL aggr ( sum(V) , ID) )

For sum(V) will have to put in instead your expression that you want the Min & Max of.

Not sure if I have explained that well, so see attached example qvw.

mohamed_ahid — Thu, 04 Sep 2014 11:55:07 GMT

Thank you everybody ,you were perfect !