topic Re: Pivot table Exp hidding in QlikView

Pivot table Exp hidding

Wed, 23 Jan 2013 06:13:25 GMT

Hi guys

I have a pivot table in the attached format.....

I want to hide the Exp2, Exp3 for Budget , and Exp3 for 2011 Dimension value because its values are null .....

Is it possible to do ??????

sujeetsingh — Wed, 23 Jan 2013 06:45:44 GMT

hi,

you can use ISnull() function

and may be use conditional option

Wed, 23 Jan 2013 07:58:29 GMT

can you attached a sample application

er_mohit — Wed, 23 Jan 2013 09:09:21 GMT

hii

create a variable and use that variable as per condition like

if(null1=' ',Null=0,Null=1)

here Null is my variableand null1 is fieldname.

if suppose you have data then else condition true or if not then it hide that expression.

Wed, 23 Jan 2013 09:53:12 GMT

hi mohit thanks for the reply ... but can you please attach a sample application....

It will be a great help

er_mohit — Wed, 23 Jan 2013 10:21:57 GMT

see the attached file

in this already hide but if you uncheck in conditional expression then you 'll see that

hope it helps