Pivot table multiple expression as column find the max row value

wenkew186 — Sat, 16 Nov 2024 03:04:51 GMT

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.

Dimension	Exp1	Exp2	Exp3	Exp4	Exp5	...
A	value	value	value	value	value	...
B	value	value	value	value	value	...
...	...	...	...	...	...	...

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！

Re: Pivot table multiple expression as column find the max row value

marcus_sommer — Mon, 08 Jul 2019 12:11:27 GMT

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

- Marcus

topic Pivot table multiple expression as column find the max row value in QlikView

Pivot table multiple expression as column find the max row value

Re: Pivot table multiple expression as column find the max row value