topic Re: parameter for pivot in QlikView

parameter for pivot

Anonymous — Mon, 22 Jul 2013 12:02:58 GMT

hi,

i made in pivot an expression like this :

count(fullorder)

and i want that the users will type number (anywhwre) , and the pivot will show only the data with the same number on that exp.

is it possibele ?

hope it's clear.

thanks'

yarin.

er_mohit — Mon, 22 Jul 2013 12:07:40 GMT

create a variable press ctrl + alt + v then add a variable

Vcount

and in expression side write

if(count(fullorder)=Vcount,count(fullorder))

if you want that your field fullorder with same of variable then try this expression

if(fullorder=Vcount,fullorder)

hope it helps

Anonymous — Tue, 23 Jul 2013 06:36:04 GMT

hi,

thanks' but my goal is that the users will write number in Vcount, and the data that show will be only with the same value that the usre type.

my exp. go like this:

if(count({$<_Flag={ord,InvAdel},[linests]={'ok'},[lineready]={'not'}>} [ordline])=Vcount,

count({$<_Flag={ord,InvAdel},[linests]={'ok'},[lineready]={'not'}>} [ordline]))

the column apear o.k but i want to show only the line in the pivot with the same values in that column and the Vcount.

is it possible ?

hope it's clear.

thanks'

yarin.

er_mohit — Tue, 23 Jul 2013 06:43:50 GMT

ok then try this way

if(Vcount=count({$<_Flag={ord,InvAdel},[linests]={'ok'},[lineready]={'not'}>} [ordline]),

count({$<_Flag={ord,InvAdel},[linests]={'ok'},[lineready]={'not'}>} [ordline]),null())