Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
MA1
Contributor III
Contributor III

Rank in Table

Hi

I try to get Rank for each Products, but now I am getting only for first Product.

Maybe Can you help me?

Thanks a lot

1 Solution

Accepted Solutions
prat1507
Specialist
Specialist

Hi

If you need ranks product wise use

=Rank(-aggr( Num(Rank( total Sum( Q) ,4)), Date,Product),Product)

View solution in original post

7 Replies
zhadrakas
Specialist II
Specialist II

try this

=Rank( total Sum( Q) ,4)

tresesco
MVP
MVP

May be this:

=aggr( Rank( total Sum( Q) ,4), Date, Product)


Or simply


=Rank( total Sum( Q) ,4)


MA1
Contributor III
Contributor III
Author

I want to get

 

Product11.08.20173
Product12.08.20171
Product13.08.20172
Product21.08.20171
Product22.08.20172
Product23.08.20173
prat1507
Specialist
Specialist

Hi

If you need ranks product wise use

=Rank(-aggr( Num(Rank( total Sum( Q) ,4)), Date,Product),Product)

sunny_talwar

Try this

=Aggr(Rank(Sum(Q) ,4), Product, Date)

Capture.PNG

MA1
Contributor III
Contributor III
Author

Thanks a lot

zhadrakas
Specialist II
Specialist II

you dont Need so much code

Rank(aggr( Sum( Q) , Product, Date),4)