Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

filtering expression

Hi is there a way to filter a expression:

 

ITEM_NOSalesMarginNegative Margin Flag
$20,000.00$30,000.00Positive Margin
SVR$0.00($10,006.88)Negative Margin
VRC$0.02($23.88)Negative Margin
FEL$0.02$0.02Positive Margin
OSE$0.03$0.03Positive 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

6 Replies
Highlighted
Creator II
Creator II

Re: filtering expression

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

Highlighted

Re: filtering expression

What is your expression for Margin?

Highlighted
Creator
Creator

Re: filtering expression

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

So i guess there is no way then?

Highlighted
Creator
Creator

Re: filtering expression

$(vMargin)

its a variable expression.

Highlighted
Creator
Creator

Re: filtering expression

I can do "searchable" thats an option

Highlighted

Re: filtering expression

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

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