Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
devarasu07
Master II
Master II

Rank issue?

Hi All,

Kindly refer to the below screen shot, I've tried to created Calculated dimension as "Peak Sold Qty rank" and it's based Singapore Peak Sold Qty, it's working fine most the case and only few case like below screen shot highlighted in yellow the rank value not correct. can you advise me how to resolve this issue? thanks

Requirement: Report display based on Singapore Peak Sold (high to low Qty i.e descending order)

Note: ranking group based on Launch, Theme,Theme Name

Capture.JPG

Cal.dimension:

Peak SoldQty Rank

=aggr(Rank(Sum(Aggr(max({<Year={"*"},Week= {"*"},Country={'SINGAPORE'},ArticleNo>}

aggr(sum({<Year={"*"},Week= {"*"},Country={'SINGAPORE'},ArticleNo>}SoldQty),Year,Week,ArticleNo)),ArticleNo)),4)

,MaterialHuddleGrpDesc,Launch_No,ThemeGroup,ThemeName,ArticleNo)

Measure:

Peak Sold

if(Dimensionality() = 5, Max({<Year={"*"},Week= {"*"},ArticleNo>}Aggr(sum({<Year,Week,ArticleNo>}SoldQty),ArticleNo, Week,Year)),

max({<Year={"*"},Week= {"*"},ArticleNo>}

aggr(sum({<Year={"*"},Week= {"*"},ArticleNo>}SoldQty),Year,Week,Country,ArticleNo)))

Thanks,

Deva

0 Replies