Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Highlighted
srinivasa1
Contributor II

pivot table experssion

Hi


Im geeting Zero values is in my pivot table expressions.when i drag the group dimension in to the vertical my expressions is showing zero values which are not related to that perticular group.

How to hide this not related expression for that group.

Thanks in advance.

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: pivot table experssion

You can't. The expression is always shown for all values of the dimension. You cannot change that behaviour.


talk is cheap, supply exceeds demand
Highlighted
srinivasa1
Contributor II

Re: pivot table experssion

Hi

Thanks for you replay. I have done IT dimension we need to supress Null value, it will work.

Highlighted
er_mohit
Honored Contributor II

Re: pivot table experssion

check on supress zero value in presentation tab..