topic Re: Rank should not be change when user select in App Development

Rank should not be change when user select

KNRaju105630 — Wed, 29 Mar 2023 12:46:33 GMT

Hi Community,

below is my table, I have calculated RANK - but when user select any product changing the RANK, but it should not change the RANK (if user select or not)

LOAD * INLINE [
Category, Sub Category, Product, Sales
Mobiles, Nokia, N1, 12
Mobiles, Nikia, N2, 2
Mobiles, Samsung, S1, 25
Mobiles, Samsung, S2, 7
Mobiles, Samsung, S3, 7
Mobiles, IPhone, I++, 9
Books, Qlik, QlikView, 5
Books, Qlik, ABC, 30
Books, Qlik, BCA, 30
Books, Qlik, XYZ, 30
Books, Qlik, XAB, 30
Books, Qlik, ABG, 30
Books, Tableau, Tab, 10
Books, Spotfire, SF, 8
];

Thanks in advance!

Re: Rank should not be change when user select

KNRaju105630 — Wed, 29 Mar 2023 12:47:22 GMT

@tresB ..

Anyone can help please - bit urgent!

Re: Rank should not be change when user select

LucasBarbosa — Wed, 29 Mar 2023 12:50:44 GMT

Hello @KNRaju105630

A simple way to do this is:

Use the aggr graph function (The Aggr function is used for nested aggregations, in which its first parameter is calculated once per dimensional value);
Use TOTAL for the calculation to be done in all possible values;
Use the identifier 1 in the set analysis to receive all the expression data regardless of the filter used;

Resulting in the following expression:

aggr(rank(total sum({1} Sales),1,2),Product)

Without any filter:

With product filter = S2:

reading references:

1 - Rank()

2 - TOTAL

3 - Aggr()

Re: Rank should not be change when user select

Marcos112 — Thu, 30 Mar 2023 18:17:07 GMT

Hello Everyone,

Hello Lucas,

Do you know , how can i do the next?

I think it's a simple query, I need to count the dates, I'm using the rank function that gives me the expected result, the problem is when I filter by a date, the rank returns to 1, so I need it to ignore the selection of that field(Fecha)

Thanks in advance