How to hide some columns in Pivot Chart

[kamal_sanguri]

Hi,

I am just trying to find out a way to hide some expression columns where there is no value...

For example, I do not want to show the highlighted columns as they do not have any value...

Any help would be greatly appreciated... Thanks much in advance.

Attaching the file as well..

Kamal

[Peter_Cammaert · Accepted solution]

There is a technique that allows you to hide expression columns that do not contain any (sensible) data from Pivot Tables. It works by turning the expressions into dimension values of their own. In your case, those would be 'YTD Incurred' and 'FY Forecast' that should become dimension values.

See this discussion for a thorough explanation: Logic

Best,

Peter

[timanshu]

Hi Kamal,

write this in conditional :

sum(TOTAL sum([Fy Forecast]))<>  0 and  not isnull( sum(TOTAL sum([Fy Forecast])) )

[kamal_sanguri]

It didn't work..

[Peter_Cammaert]

Like you said, tricks with Conditional Show won't work here because they are bound to suppress all instances of the expression.

For a technique that does work, see here: http://community.qlik.com/message/731240#731240

[timanshu]

Hi kamal,

Kindly see the attached qvw.

It works.

[kamal_sanguri]

Hello,

This method does not work... it hides FY Field entirely.. Please check for 2015--March

We have figures for 2015-Mar but it hides that as well...

Thanks,

Kamal

[kamal_sanguri]

Hi Peter,

Although it took me long to understand and incorporate the logic in my app but it worked..

[Peter_Cammaert]

In the future, never hesitate to ask additional questions about tricks that may look obscure at first. I already did more than a few wrestling matches with QlikView and gladly would have tried to spare you from them.

[timanshu]

Hi Kamal,

Ok. My mistake. The method will not work for you. Can you explain me the way you done or if you could  just attached qvw with issue resolved?