topic Re: How to Hide Expression in Pivot Chart in QlikView

How to Hide Expression in Pivot Chart

Mon, 26 Jan 2026 18:19:17 GMT

Hi Guys

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

Regards,

Singam.

Re: How to Hide Expression in Pivot Chart

santhoo_san — Thu, 11 Jun 2015 06:50:32 GMT

use Conditional check box option under Expressions

Re: How to Hide Expression in Pivot Chart

avinashelite — Thu, 11 Jun 2015 06:50:45 GMT

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

avinashelite — Thu, 11 Jun 2015 06:54:03 GMT

Re: How to Hide Expression in Pivot Chart

Thu, 11 Jun 2015 06:55:59 GMT

Hi Avinash

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

Re: How to Hide Expression in Pivot Chart

avinashelite — Thu, 11 Jun 2015 07:04:56 GMT

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

Re: How to Hide Expression in Pivot Chart

Thu, 11 Jun 2015 07:11:10 GMT

We tried that option it is not working

Re: How to Hide Expression in Pivot Chart

avinashelite — Thu, 11 Jun 2015 07:12:27 GMT

can you please share the app

Re: How to Hide Expression in Pivot Chart

Peter_Cammaert — Thu, 11 Jun 2015 08:09:07 GMT

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