Discussion board where members can get started with QlikView.
Hi is there a way to filter a expression:
I want to filter on "Negative Margin Flag"
I have already done if(margin<0, 'neg margin', 'positive margin') in a dimension
I just want to know any way to filter that expression. expression is if([margin]<0, 'neg margin', 'positive margin')
Create the Margin Flag field in the script and then just have a list box
What is your expression for Margin?
I dont have access to developer view. I can only create expressions and calculated dimensions.
So i guess there is no way then?
its a variable expression.
I can do "searchable" thats an option
With Qlik being case sensitive try Margin with a capital M.
But probably better to try your dollar expansion $(vMargin)