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

How to use Rank function to show top brands?

Hello Friends,

Can any one tell me how to use Rank function in dimension of pivot table to show top Brands.

As shown in attached screen shot in first column there is a cyclic drill having fields 'Country' and 'Nil' where nil is blank.

If I select 'Nil' in first cyclic drill then it should show top brands of all countries as shown in fig 1

And if I select 'Country ' in cyclic drill then it have to show country wise top brands.  ex. As shown in Fig 2 in USA there are five top brands A,B,C,D,E

Regards,

Ashish

0 Replies