topic Re: Pivot table in QlikView

Pivot table

Wed, 04 Jun 2014 03:43:46 GMT

hi i am trying to to display the top 10 highest number of values which is in the pivot table is there any way that i can do this. i have attached an image of the pivot table.

can some one plz help me much appreciated..

thank you in advance

Re: Pivot table

eduardo_sommer — Wed, 04 Jun 2014 03:51:55 GMT

You can change the expression, from Count(src) to if(rank(Count(src)<11,Count(src))

Eduardo

Re: Pivot table

Wed, 04 Jun 2014 04:03:35 GMT

sorry this is not working i am getting an empty table

Re: Pivot table

Wed, 04 Jun 2014 04:08:59 GMT

can u share ur qvw file?

Re: Pivot table

eduardo_sommer — Wed, 04 Jun 2014 04:11:27 GMT

Another possibility is to change from pivot table to straight table (considering you have oly one dimension in your table) and check 'Restrict which values are displayed using the first expression, in Dimension Limits tab of the properties of the straight table. Also set 10 as the largest n Values and unmark the Show Others option in the same tab.

Eduardo

Re: Re: Pivot table

Wed, 04 Jun 2014 04:20:04 GMT

try this in pivot table =if(rank(Sum (src))<=10,sum(src),0)

Re: Pivot table

amit_saini — Wed, 04 Jun 2014 04:26:07 GMT

Hi Shalani,

Try this:

=aggr(if(Rank(sum(Investment))<=10,Investment),Investment) (For calculating Top 10)

Thanks,

Re: Pivot table

Wed, 04 Jun 2014 05:11:06 GMT

this gives me the correct answr but i am getting a total count on the 1st row i dnt want that count 😕

Re: Pivot table

Wed, 04 Jun 2014 05:23:18 GMT

hey this worked but the correct one is =if(rank(Count (src))<=10,Count(src),0)

thank you so much for your help

Re: Pivot table

Wed, 04 Jun 2014 05:30:21 GMT

is there any possible way of displaying the average next to each count??

Re: Re: Pivot table

Wed, 04 Jun 2014 05:34:59 GMT

for calculating avg I sud see ur datamodel m not sure what ur src is

Re: Re: Re: Pivot table

Wed, 04 Jun 2014 07:00:26 GMT

this a test attachment hr i want to show a percentage next to the value column in the table

Re: Pivot table

eduardo_sommer — Wed, 04 Jun 2014 10:53:00 GMT

In the expression tab mark No Total for your expression.

Eduardo