Discussion board where members can get started with QlikView.
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)
Variable1 = N
Is this possible?
Go to Solution.
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'.
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
Thanks thta really helps is there a way to do it in bar graphs as well as tables/charts?
thanks for this I had tried the if statement, but iot was the values on data points which caught me out works a treat..