Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
@tresesco ..
Anyone can help please - bit urgent!
Hello @KNRaju105630
A simple way to do this is:
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()
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