Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

srinivasa1
Contributor

Hide pivot table experssion if value is 0

Hi im doing month on month difference for selected year i have used before function but its creates one xtra cols wiht 0 value can anyone guide me how i can hide that.

Have attached application

Thanks in advance.

4 Replies
sushil353
Honored Contributor II

Re: Hide pivot table experssion if value is 0

Hi,

please find  the modified app.

HTH

Sushil

srinivasa1
Contributor

Re: Hide pivot table experssion if value is 0

Hi,

Thanks for try.still it shows jan col i need hide that cols if all cols value are zero

er_mohit
Honored Contributor II

Re: Hide pivot table experssion if value is 0

hiii try this in expression tab of pivot table and

cheked on conditional  and in that write this expression

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

null1 is my field name

hope it helps

see the atached image

srinivasa1
Contributor

Re: Hide pivot table experssion if value is 0

Thanks.Its not working sir, i have attached my sample app in this thread.i need to hide cols if all value is 0. eg Jan cols

thanks

Community Browser