topic Showing Expression dependant on Variable in QlikView

Showing Expression dependant on Variable

Tue, 31 May 2011 14:59:42 GMT

Hello

If I have four expressions:

If i wanted to show the values for expression B in the chart depenadant only when another condition has been for filled (for instance if variable1 said Y)

for Example

Variable 1=Y

Variable1 = N

Is this possible?

Jon

Showing Expression dependant on Variable

vincent_ardiet — Tue, 31 May 2011 15:17:44 GMT

Hi,

In the Presentation tab of your chart object properties you will find the list of all your dimensions and expressions.

If you choose the B expression, then below the list, you can click on conditionnal display and put the following expression in it : Variable1=Y

Regards,

Vincent

Showing Expression dependant on Variable

Tue, 31 May 2011 15:21:14 GMT

Thanks thta really helps is there a way to do it in bar graphs as well as tables/charts?

Jon

Showing Expression dependant on Variable

vincent_ardiet — Tue, 31 May 2011 15:42:41 GMT

In bar graphs you can write your expression as : =if(Variable1='Y',B) with B containing your expression.

It works like no expression was here.

But if you choose to have values on data points for this expression, it will appear like a 0 expression.

So in this case, uncheck the "values on data points", then click on the little + beside your expression, go to the "Show Value" propertie and in the definition field type Variable1='Y'.

Regards,

Vincent

Showing Expression dependant on Variable

Tue, 31 May 2011 15:48:12 GMT

thanks for this I had tried the if statement, but iot was the values on data points which caught me out works a treat..