Discussion Board for collaboration on QlikView Layout & Visualizations.
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 ?
try something like this :
= Not IsNull(PriceBreak)
I thought conditional showing or not, needs an expression like IF(condition,1,0) to show if condition is true... ?
Try this in the conditional box of the expression:
If(GetSelectedCount(PriceBreak)=0, 1, 0)
peschu82: Not really... it is enough to say
If condition returns false, the object is hidden, otherwise it is shown.
The longer version
works as well, but it is not necessary
i tried this one too but
same .. it hides but not showing again