Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paul_scotchford
Valued Contributor

Hiding an Expression value conditionally

Greetings All,

I have a pivot table chart that when I select a specific filter I require certain Expression Values to become hidden on my chart, for example if a

user clicks (or is already selected by association) a Retail Price Break, the Budget expression value should become hidden as budgets

are not at the Price Break granularity (Price Break is the finest grain for this pivot table chart).

I have tried using the Conditional option for the expression, but I can only get it to be hidden when the PriceBreak is >0, I would prefer if

I can test the actual list box (that contains the price breaks) has been selected.

Has anyone tried or know how to do this ?

Many thanks

Paul

5 Replies
MVP
MVP

Re: Hiding an Expression value conditionally

try something like this :

= Not IsNull(PriceBreak)

peschu123
Contributor III

Re: Hiding an Expression value conditionally

I  thought conditional showing or not, needs an expression like IF(condition,1,0) to show if condition is true... ?

alindquist
New Contributor III

Re: Hiding an Expression value conditionally

Try this in the conditional box of the expression:

If(GetSelectedCount(PriceBreak)=0, 1, 0)

mov
Esteemed Contributor III

Re: Hiding an Expression value conditionally

peschu82: Not really...  it is enough to say

condition

If condition returns false, the object is hidden, otherwise it is shown.

The longer version

IF(condition,1,0)

works as well, but it is not necessary

Not applicable

Re: Hiding an Expression value conditionally

i tried this one too but

same .. it hides but not showing again

Community Browser