Solved: How to show only Top 10 values in pivot table - Qlik Community

Report Inappropriate Content · ‎2015-06-30

Hi Frnz,

Please help me. I would like display Top 10 values. But I am getting all values. Please find the attached QVW.

MK_QSL · ‎2015-06-30

Use Pivot Table

Dimension

1) YEAR

2) Calculated DImension

=AGGR(IF(Rank(SUM(ULT_REVENUE),4)<=10,L4ACCTNAME),YEAR, L4ACCTNAME)

TICK SUPPRESS WHEN VALUE IS NULL

Expression

Whatever you want

View solution in original post

PrashantSangle · ‎2015-06-30

Hi,

Use Rank()

Search in Community,

Top 10 using Rank()

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

jsingh71 · ‎2015-06-30

See This:

Calculating TOP 10 VALUES in PIVOT TABLE

Gysbert_Wassenaar · ‎2015-06-30

The top 10 What of What?

talk is cheap, supply exceeds demand

buzzy996 · ‎2015-06-30

goto --dimeniosn limits tab--

see below,

Report Inappropriate Content · ‎2015-06-30

YEAR wise Top 10 and I need to show Account name also in Pivot table

Report Inappropriate Content · ‎2015-06-30

In Pivot table, no dimension limits tab

buzzy996 · ‎2015-06-30

then u can use the rank function on ur expression.

some thing like this..

=Sum(Aggr(if(Rank(Sale)<=10,on-whichever the field ur calulcating fro example sales),Account name,Sale))

MK_QSL · ‎2015-06-30

Use this as calculated Dimension instead of L4ACCTNAME

=AGGR(IF(Rank(SUM(ULT_REVENUE),4)<=10,L4ACCTNAME),YEAR, L4ACCTNAME)

Tick suppress when value is null

Report Inappropriate Content · ‎2015-06-30

I will try..Thanks