filtering expression

[jadams123]

Hi is there a way to filter a expression:

ITEM_NO	Sales	Margin	Negative Margin Flag
	$20,000.00	$30,000.00	Positive Margin
SVR	$0.00	($10,006.88)	Negative Margin
VRC	$0.02	($23.88)	Negative Margin
FEL	$0.02	$0.02	Positive Margin
OSE	$0.03	$0.03	Positive Margin
KHC	$0.06	($119.94)	Negative Margin
KND	$0.09	($1.54)	Negative Margin

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

j

[Anonymous]

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

[sunny_talwar]

What is your expression for Margin?

[jadams123]

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

So i guess there is no way then?

[jadams123]

$(vMargin)

its a variable expression.

[jadams123]

I can do "searchable" thats an option

[Anonymous]

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

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