Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Have a look at this example.
Regards,
Kaushik Solanki
See Re: Calculating TOP 10 VALUES in PIVOT TABLE
Or search: community.qlik.com/search.jspa?q=top+10+rank
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
Multiply the values to rank with -1 so the ranking inverts.
Please post example expression here then I can understand easily..
if(rank( -sum(Sales)) <= 10, TrueExpressionHere , FalseExpressionHere )
Hi,
Have a look at this example.
Regards,
Kaushik Solanki
Hi Gysbert,
To calculate top 10 i'm used this formula
(Aggr(Rank(Avg([Over All Score])),S_PERNR_Name) <= 10 ,S_PERNR_Name)
if(Aggr(Rank(-Avg([Over All Score])),S_PERNR_Name) <= 10 ,S_PERNR_Name)
Hi Kaushik,
Thanks for your reply..
I seen that attachment it was explained by clearly .......
Thanks Kaushik..