topic Re: Showing Top 10 Total in QlikView

Showing Top 10 Total

abhaytrip — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

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

Any help regarding this would be appreciated !
Thanks ,
Abhay

tresB — Fri, 02 Feb 2018 10:31:00 GMT

Try like this:

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

abhaytrip — Fri, 02 Feb 2018 10:35:49 GMT

Yep , This did help !

Thanks a lot.

alis2063 — Fri, 02 Feb 2018 11:21:52 GMT

You could also simply marked the Total mode as below,

isingh30 — Fri, 02 Feb 2018 16:02:23 GMT

Please check this. Let me know.

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

Thanks.