topic Re: filtering expression in QlikView

filtering expression

jadams123 — Wed, 25 Nov 2020 16:16:04 GMT

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')

Thanks

Anonymous — Fri, 06 Jan 2017 16:22:07 GMT

Create the Margin Flag field in the script and then just have a list box

sunny_talwar — Fri, 06 Jan 2017 16:24:40 GMT

What is your expression for Margin?

jadams123 — Fri, 06 Jan 2017 16:28:52 GMT

I dont have access to developer view. I can only create expressions and calculated dimensions.

So i guess there is no way then?

jadams123 — Fri, 06 Jan 2017 16:58:25 GMT

$(vMargin)

its a variable expression.

jadams123 — Fri, 06 Jan 2017 16:59:33 GMT

I can do "searchable" thats an option

Anonymous — Fri, 06 Jan 2017 17:01:32 GMT

With Qlik being case sensitive try Margin with a capital M.

But probably better to try your dollar expansion $(vMargin)