Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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
Contributor II

Re: How to Hide Expression in Pivot Chart

use Conditional check box option under Expressions

Re: How to Hide Expression in Pivot Chart

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

Re: How to Hide Expression in Pivot Chart

t.pngt2.png

Not applicable

Re: How to Hide Expression in Pivot Chart

Hi Avinash

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

Re: How to Hide Expression in Pivot Chart

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

Not applicable

Re: How to Hide Expression in Pivot Chart

We tried that option it is not working

Re: How to Hide Expression in Pivot Chart

can you please share the app

Re: How to Hide Expression in Pivot Chart

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

Community Browser