topic rank function for fixed row in QlikView

rank function for fixed row

Sun, 04 Sep 2016 13:21:42 GMT

Hi everybody.

I need to build a chart, which returns the rank of fixed ID, where the current selection is taken into account.

In this example the chart (highlighted in red) musst display the value "3".

When I kick out ID 2 from the current selection the rank musst change to "2",

as ID 4 becomes the second lowest value of the selection.

thank you for your help

best wishes.

Anil_Babu_Samineni — Sun, 04 Sep 2016 15:46:12 GMT

Can you post sample application?

ecolomer — Sun, 04 Sep 2016 18:46:29 GMT

See this example

ecolomer — Sun, 04 Sep 2016 18:49:18 GMT

And this one

Mon, 05 Sep 2016 11:07:55 GMT

Thank you for your help, unfortunately I'm working with a student license, so I can't upload a sample.

I want the chart to display only values for ID=vSet_ID (4 in this case)

(ID, KPI, rank)

The chart is a straight table, with no dimensions.

The expressions are shown in the picture.

The set expressions: min({1<ID = {4}>}ID) works for the columns ID and KPI, but not for the rank expression.

I hope I could make the problem clear.