Discussion Board for collaboration related to QlikView App Development.
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 242 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)
maybe (replace sum.... with your expression for V column)
sum (value of transactions ) for week 12 and 11 / sum (value of transactions ) for week 9 and 10,
View solution in original post
What are the dimension in this table?
You can get the max by
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.
Thank you everybody ,you were perfect !