Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show records

Hi guys,

I have a straight table which I would like to only show records where a field is 5.00 or below

Capture.PNG

The field is called Margin.

The reason I would like to do this is because when I show all records the table says "object out of memory"

Any help would be appreciated

Thanks

1 Solution

Accepted Solutions
sunny_talwar

Have you tried this:

=If((([Discounted Price] - [Product Cost]) / [Discounted Price] * 100) <= 5, (([Discounted Price] - [Product Cost]) / [Discounted Price] * 100))

View solution in original post

17 Replies
sunny_talwar

Replace your existing expression with this may be:

If(YourExpression <= 5, YourExpression)

Anonymous
Not applicable
Author

My expression is this! Can you help?

=(([Discounted Price] - [Product Cost]) / [Discounted Price] * 100)

sunny_talwar

Have you tried this:

=If((([Discounted Price] - [Product Cost]) / [Discounted Price] * 100) <= 5, (([Discounted Price] - [Product Cost]) / [Discounted Price] * 100))

Not applicable
Author

If((([Discounted Price] - [Product Cost]) / [Discounted Price] * 100)<=5,(([Discounted Price] - [Product Cost]) / [Discounted Price] * 100))

Regards,

KKR

Anonymous
Not applicable
Author

Ah that's perfect. Thanks guys.

Can I exclude the values where the Margin is now "-" from my table - I set this to 20 as a test...

Capture.PNG

sunny_talwar

It should have already excluded them. Are there more expressions in this table?

Anonymous
Not applicable
Author

Ah yes, I thought that might be the case.  I have one other expression within the table..

sunny_talwar

Why don't you restrict the other expression like this:

If(not IsNull([Margin]), yourExpression)

Where Margin is the label of the above expression (Margin should turn blue when you use the above expression)

HTH

Best,

Sunny

Anonymous
Not applicable
Author

Hi Sunny

I tried this but it didn't work.. This is my other expression

=If(not IsNull([Margin]), (pricing_oplistm_price) - (pricing_oplistm_price/100)*pricing_price_deal_discount).  It's also broken my margin expression too... Haha

Capture.PNG