topic Re: sorting in pivot table in QlikView

sorting in pivot table

Wed, 18 Apr 2012 11:22:02 GMT

how to restrict values in the pivot table using where condition???

sorting in pivot table

Wed, 18 Apr 2012 11:28:39 GMT

Hi ,

see if you want to sort go to Sort Tab and Sort dimension alpabetically or numerically

and if you whant to filter data then you can use where at script level but you can not

use where at chart there you can use if condition or better use set analysis to filter

the desired data to show in charts

Regards,

Anant Dubey

sorting in pivot table

Wed, 18 Apr 2012 11:33:19 GMT

i have to create a pivot table in which the situation is like this..

i have a column 'a' in which there are 20000 rows and i want to pick the top twenty rows from them on the basis of

a third column price so how can i use it in the load script or with the help of ranking???

sorting in pivot table

ToniKautto — Wed, 18 Apr 2012 11:37:03 GMT

Please specify which QlikView version you are using, since this can be solved a bit differently in versions 10 and 11 for example. A sample QVW would also be helpful, as you can then be advised based on the actual expressions and dimensions in your chart.

Re: sorting in pivot table

Wed, 18 Apr 2012 12:08:47 GMT

Hi,

just declare a global variable, use a input box attach global variable to it.

use logic something like this :

=Sum(Aggr(if(rank(sum(Sales))<=V1,sum(Sales)),ID))

which means if you want Top 20 rows the just provide 20 in input box or if Top 10 rows

then provide it in input box so chart will contain data of that no of rows.

just see atached application.

Thanks

Anant Dubey

Re: sorting in pivot table

Wed, 06 Jun 2012 09:35:06 GMT

hi Toni

i am using version 10.

Re: sorting in pivot table

Wed, 06 Jun 2012 09:43:49 GMT

can u tell me what do u mean by a global variable and how i can attach it to apivot table.