Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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!!

Tags (4)
1 Solution

Accepted Solutions
Not applicable

Rating in dimension (pivot or strong table)

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

Jason Michaelides, tnx for help!

3 Replies
jason_michaelid
Honored Contributor II

Rating in dimension (pivot or strong table)

Try:

Rank(Sum(TOTAL <Category> Quantity))

and

Rank(Sum(TOTAL <Category> Price))

Hope this helps,

Jason

Not applicable

Rating in dimension (pivot or strong table)

the result is min-max:

1-1322

1-1322

1-1322

1-1322

1-2372

1-2372

1-2372

1-2372

Not applicable

Rating in dimension (pivot or strong table)

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

Jason Michaelides, tnx for help!

Community Browser