sorting in pivot table

[#1]

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

[#2]

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

[#3]

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???

[ToniKautto]

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.

[#5]

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

[#6]

hi Toni

i am using version 10.

[#7]

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