Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot table Exp hidding

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

5 Replies
sujeetsingh
Honored Contributor III

Re: Pivot table Exp hidding

hi,

you can use  ISnull() function

and may be use conditional option

Not applicable

Re: Pivot table Exp hidding

can you attached a sample application

er_mohit
Honored Contributor II

Re: Pivot table Exp hidding

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.

Not applicable

Re: Pivot table Exp hidding

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

It will be a  great help

er_mohit
Honored Contributor II

Re: Pivot table Exp hidding

see the attached file

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

hope it helps

Community Browser