Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Hide Expression in Pivot Chart

Hi Guys

       Is there any option to Enable and hide expression in Pivot chart

Regards,

Singam.

8 Replies
santhoo_san
Partner - Creator II
Partner - Creator II

use Conditional check box option under Expressions

avinashelite

go to expression  tab , check on conditional of the expression

here use: =false()

then go to presentation tab and un check the suppress zero option

avinashelite

t.pngt2.png

Not applicable
Author

Hi Avinash

            Thanks for replying .But in conditional what type of expression we can wright

avinashelite

you can use any type of expression like based on certain calculated condition or based on selection anything you can use.

Not applicable
Author

We tried that option it is not working

avinashelite

can you please share the app

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Hiding Expression columns in a Pivot isn't as straightforward as in a Straight table. There are multiple workarounds to get it to work, but they all depend on what you are trying to accomplish. The example below uses Avinash R's technique to show and hide an expression by selecting its name from a list.

Another solution would be to create an artificial dimension (using ValueList() function) to automatically hide an Expression column without values

To get it to work in your document, please provide more details or upload a sample app, as requested.

Best,

Peter