topic Re: Hiding an Expression value conditionally in QlikView

Hiding an Expression value conditionally

paul_scotchford — Mon, 05 Aug 2013 05:11:11 GMT

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

tresB — Mon, 05 Aug 2013 05:19:16 GMT

try something like this :

= Not IsNull(PriceBreak)

peschu123 — Mon, 05 Aug 2013 07:46:02 GMT

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

Anonymous — Fri, 24 Jan 2014 17:43:48 GMT

Try this in the conditional box of the expression:

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

Anonymous — Fri, 24 Jan 2014 19:11:50 GMT

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

Mon, 15 Jun 2015 12:08:04 GMT

i tried this one too but

same .. it hides but not showing again