Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mohamed_ahid
Partner
Partner

Max value within a pivot table

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

          )

     )

View solution in original post

4 Replies
maxgro
MVP
MVP

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

          )

     )

View solution in original post

MK_QSL
MVP
MVP

What are the dimension in this table?

You can get the max by

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

bill_markham

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
Partner
Partner
Author

Thank you everybody ,you were perfect !