Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Rank results of different calculations

Hi all,

I'm in a tricky situation and hope someone can help.

How do I rank the results of different calculations and just report the top value? All of this in the same expression if possible.

For example, I may have the following results:

sum(A) * vSVC1 = 5

sum(B) * vSVC2 = 3

sum(C) * vSVC3 = 2

sum(D) * vSVC4 = 0

In this case the expression result should be 5.

Please note the above variables can be changed by the user within an input box.

Thank you so much.

Linda

1 Solution

Accepted Solutions

Re: Rank results of different calculations

try,

Create a chart

Dimension:

YourDimesion

Expression:

=rangemax(sum(A)*$(vSVC1),sum(B)*$(vSVC2),sum(C)*$(vSVC3),sum(D)*$(vSVC4))

2 Replies

Re: Rank results of different calculations

try,

Create a chart

Dimension:

YourDimesion

Expression:

=rangemax(sum(A)*$(vSVC1),sum(B)*$(vSVC2),sum(C)*$(vSVC3),sum(D)*$(vSVC4))

Not applicable

Re: Rank results of different calculations

Brilliant!

Thanks :-)

Community Browser