Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
abhaytrip
Contributor

Showing Top 10 Total

Hi Qlikers,

Since i'm new I thought that this would be the best forum do ask questions.

Issue: I want to show the Top 10 total in the pivot table. Just like in the picture below.

sum2.PNG

But what is happening is i'm able to show only the Others Total and the Complete Total. (Like the picture below)

sum1.PNG

So how do I get the Top 10 Total and display Others with it too.

Any help regarding this would be appreciated !
Thanks ,
Abhay

1 Solution

Accepted Solutions
MVP
MVP

Re: Showing Top 10 Total

Try like this:

Exp:  if(Dimensionality()=0,Sum({<Data={"=Rank(Sum(Data))<11"}>}Data), Sum(Data))

Capture.JPG

View solution in original post

4 Replies
MVP
MVP

Re: Showing Top 10 Total

Try like this:

Exp:  if(Dimensionality()=0,Sum({<Data={"=Rank(Sum(Data))<11"}>}Data), Sum(Data))

Capture.JPG

View solution in original post

abhaytrip
Contributor

Re: Showing Top 10 Total

Yep , This did help !

Thanks a lot.

alis2063
Contributor II

Re: Showing Top 10 Total

You could also simply marked the Total mode as below,

EXP.png

isingh30
Valued Contributor

Re: Showing Top 10 Total

Please check this. Let me know.

Expression  =sum({$<Customer ={A,B,C}>}Sales)

Thanks.