Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
wenkew186
Creator
Creator

Pivot table multiple expression as column find the max row value

Dear expert,

I have a pivot table, one dimension and multiple expression columns. I want compare all columns value and rank it for every dimension row.

DimensionExp1  Exp2Exp3Exp4  Exp5 ...
Avaluevaluevaluevaluevalue...
Bvaluevaluevaluevaluevalue...
.....................

For example, I want get the information is  which expression column is the Max value, which one is the second, third... for dimension value "A". Then I can use the result to make the different cell's background  color.

However, for most of the expressions has different logic. i guess only just can compare values size for every row? But how to make it works?

So experts have any suggestion for this question? 

Thanks a lot for your help!

 

Labels (4)
1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

Add another expression with: rangemax(Expr1, Expr2, Expr3, ...) whereby you could use the labels of the expressions or their column() index.

- Marcus