Last 10 in Pivot table

[Anonymous]

Hi Qlikers,

I'm having a small doubt,

I want to show the last 10 values in Pivot table.

Cal you please suggest me the solution..

I know how to calculate the Top 10 values

[Gysbert_Wassenaar]

See Re: Calculating TOP 10 VALUES in PIVOT TABLE

Or search: community.qlik.com/search.jspa?q=top+10+rank

[Anonymous]

Hi Gysbert,

The above mentioned community  link will showing the how to calculate the top10

but my task is  to show the last 10 values........

Thanks & Warm regards,

Venkata Sreekanth

[Gysbert_Wassenaar]

Multiply the values to rank with -1 so the ranking inverts.

[Anonymous]

Please post example expression here then I can understand easily..

[Gysbert_Wassenaar]

if(rank( -sum(Sales)) <= 10, TrueExpressionHere , FalseExpressionHere )

[kaushiknsolanki · Accepted solution]

Hi,

Have a look at this example.

Regards,

Kaushik Solanki

[Anonymous]

Hi Gysbert,

To calculate top 10 i'm used this formula

(Aggr(Rank(Avg([Over All Score])),S_PERNR_Name) <= 10 ,S_PERNR_Name)

[Gysbert_Wassenaar]

if(Aggr(Rank(-Avg([Over All Score])),S_PERNR_Name) <= 10 ,S_PERNR_Name)

[Anonymous]

Hi Kaushik,

Thanks for your reply..

I seen that attachment it was explained by clearly .......

Thanks Kaushik..