topic Re: Rank should not change on selection in QlikView

Rank should not change on selection

rupaliqlik — Wed, 25 Nov 2020 16:16:04 GMT

Dear All ,

I have Person wise data and their ranks, but when I elect any person rank is showing 1 . and I want their actual rank. Please tell me what I should do in this scenario.

Thanks in advance.

Re: Rank should not change on selection

Anonymous — Mon, 29 May 2017 15:47:21 GMT

please prepare an example...

Re: Rank should not change on selection

ziadm — Mon, 29 May 2017 15:58:36 GMT

What is the expression .. ?

you need to ignore the dimension in the Rank expression

Re: Rank should not change on selection

rupaliqlik — Mon, 29 May 2017 16:10:05 GMT

Dear Robin,

I have data like this

load * Inline

[

NAME, Marks

Rupali, 100

Smita, 90

John, 70

Aditi, 60

Prachi, 50

Priya, 40

Rina, 20

Mehul, 10

Disha, 15

Isha, 35

];

RANK Expression: =rank(sum(Marks))

while selection rank shows 1 .

Please suggest .

Re: Rank should not change on selection

rupaliqlik — Mon, 29 May 2017 16:10:27 GMT

Dear Robin,

I have data like this

load * Inline

[

NAME, Marks

Rupali, 100

Smita, 90

John, 70

Aditi, 60

Prachi, 50

Priya, 40

Rina, 20

Mehul, 10

Disha, 15

Isha, 35

];

RANK Expression: =rank(sum(Marks))

while selection rank shows 1 .

Please suggest .

Re: Rank should not change on selection

Anonymous — Mon, 29 May 2017 16:39:08 GMT

dimension NAME

expression:

if(not isnull(Marks),rank(Sum({1} Marks)))

Re: Rank should not change on selection

ziadm — Mon, 29 May 2017 16:41:35 GMT

aggr(rank(sum( {1<NAME=>} Sales)),NAME)

Re: Rank should not change on selection

ziadm — Mon, 29 May 2017 16:42:40 GMT

aggr(rank(sum( {1<NAME=>} Marks)),NAME)

Re: Rank should not change on selection

rupaliqlik — Mon, 29 May 2017 16:47:48 GMT

thanks @ !

Re: Rank should not change on selection

rupaliqlik — Mon, 29 May 2017 16:48:15 GMT

Thanks.

Re: Rank should not change on selection

Anil_Babu_Samineni — Mon, 29 May 2017 16:52:16 GMT

You can define {1} operator in set expression. It will give constant even if selection happen

Re: Rank should not change on selection

tajmohamed30 — Mon, 29 May 2017 16:59:09 GMT

Hi Rupali,

If you got answer please mark it as answered under actions to close the discussion.

Thanks

Taj

Re: Rank should not change on selection

satishkurra — Tue, 30 May 2017 03:56:32 GMT

I would suggest using with aggregation as

=Sum(aggr(rank( sum( {$<Name=>} Marks) ), Name))

=Min(aggr(rank( sum( {$<Name=>} Marks) ), Name))

=Max(aggr(rank( sum( {$<Name=>} Marks) ), Name))