Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rating in dimension (pivot or strong table)

Hi.

CategoryItemQuantityRating_quantityPriceRating_price
foodMilk172502
foodCola104193
foodCake221701
foodBanana75164
foodСookies14355
furnitureChair441002
furnitureTable35903
furnitureSofa62306
furniturebla181804
furniturebla253755
furniturebla3161101

Category and Item is dimension.

How can i do Rating_quantity and Rating_price? (Rating in category)

Pivot or Strong table - unimportant.

Thank you!!

1 Solution

Accepted Solutions
Not applicable
Author

=Rank(sum(Qty),4,1) its work! mode 4 and format 1.

Jason Michaelides, tnx for help!

View solution in original post

3 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Try:

Rank(Sum(TOTAL <Category> Quantity))

and

Rank(Sum(TOTAL <Category> Price))

Hope this helps,

Jason

Not applicable
Author

the result is min-max:

1-1322

1-1322

1-1322

1-1322

1-2372

1-2372

1-2372

1-2372

Not applicable
Author

=Rank(sum(Qty),4,1) its work! mode 4 and format 1.

Jason Michaelides, tnx for help!