Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sonikajain
New Contributor

display OTHERS row in a straight table

Dear all,

I am  stuck in  a scenario where I need to display top 10 rows based upon gross revenue, and there are 3 dimensions in the table -

Country, City and Contact name, and the rest in a separate row ALL others.

I am able to achieve this additional rows for rest of the data when I use a single dimension, but here I have 3 dimensions, and so, the row for OTHERS is not visible.

straight table.jpg

Please help me with this.

Sonika Jain

2 Replies
deepakk
Valued Contributor III

Re: display OTHERS row in a straight table

hi Sonika,

Try the attach application.

Deepak

Not applicable

Re: display OTHERS row in a straight table

Dear Sonika,   Try adding a fourth calculated dimention like:   =aggr(If(Rank(sum(Mins)/sum(TOTAL Mins))<=10,'Top 10','Others'),Country)  To create the thwo groups. Please see file for example.  Regards  Rahul Lakhina

Community Browser