topic Re: Last 10 in Pivot table in QlikView

Last 10 in Pivot table

Anonymous — Tue, 08 Jul 2014 09:16:46 GMT

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

Re: Last 10 in Pivot table

Gysbert_Wassenaar — Tue, 08 Jul 2014 09:19:52 GMT

See Re: Calculating TOP 10 VALUES in PIVOT TABLE

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

Re: Last 10 in Pivot table

Anonymous — Tue, 08 Jul 2014 09:26:50 GMT

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

Re: Last 10 in Pivot table

Gysbert_Wassenaar — Tue, 08 Jul 2014 09:28:17 GMT

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

Re: Last 10 in Pivot table

Anonymous — Tue, 08 Jul 2014 09:31:04 GMT

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

Re: Last 10 in Pivot table

Gysbert_Wassenaar — Tue, 08 Jul 2014 09:33:34 GMT

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

Re: Re: Last 10 in Pivot table

kaushiknsolanki — Tue, 08 Jul 2014 09:34:27 GMT

Hi,

Have a look at this example.

Regards,

Kaushik Solanki

Re: Last 10 in Pivot table

Anonymous — Tue, 08 Jul 2014 09:35:27 GMT

Hi Gysbert,

To calculate top 10 i'm used this formula

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

Re: Last 10 in Pivot table

Gysbert_Wassenaar — Tue, 08 Jul 2014 09:36:45 GMT

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

Re: Last 10 in Pivot table

Anonymous — Tue, 08 Jul 2014 09:37:33 GMT

Hi Kaushik,

Thanks for your reply..

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

Thanks Kaushik..

Re: Last 10 in Pivot table

Anonymous — Tue, 08 Jul 2014 09:39:36 GMT

Hi Gysbert ,

Thanks for your reply........