topic Show records in QlikView

Show records

Anonymous — Tue, 30 Jun 2015 16:49:38 GMT

Hi guys,

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

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

Re: Show records

sunny_talwar — Tue, 30 Jun 2015 16:53:55 GMT

Replace your existing expression with this may be:

If(YourExpression <= 5, YourExpression)

Re: Show records

Anonymous — Tue, 30 Jun 2015 17:12:08 GMT

My expression is this! Can you help?

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

Re: Show records

sunny_talwar — Tue, 30 Jun 2015 17:15:35 GMT

Have you tried this:

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

Re: Show records

Tue, 30 Jun 2015 17:18:04 GMT

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

Regards,

KKR

Re: Show records

Anonymous — Wed, 01 Jul 2015 14:29:30 GMT

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...

Re: Show records

sunny_talwar — Wed, 01 Jul 2015 14:30:53 GMT

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

Re: Show records

Anonymous — Wed, 01 Jul 2015 14:33:21 GMT

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

Re: Show records

sunny_talwar — Wed, 01 Jul 2015 14:35:34 GMT

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

Re: Show records

Anonymous — Wed, 01 Jul 2015 14:45:51 GMT

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

Re: Show records

sunny_talwar — Wed, 01 Jul 2015 14:51:02 GMT

Hahahah.... Good job sunny boy....

can you paste a screenshot of both your expressions?

Re: Show records

Anonymous — Wed, 01 Jul 2015 14:54:17 GMT

Haa no worries Sunny. Appreciate the help..

=If(not IsNull([Margin]), (pricing_oplistm_price) - (pricing_oplistm_price/100)*pricing_price_deal_discount)

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

Re: Show records

sunny_talwar — Wed, 01 Jul 2015 14:57:02 GMT

Jamel Messaoud‌ not asking to copy paste the expression, but paste a screenshot of them from the application

Re: Show records

Anonymous — Thu, 02 Jul 2015 09:18:34 GMT

Sorry Sunny. Screenshot below

Re: Show records

sunny_talwar — Thu, 02 Jul 2015 09:44:49 GMT

Hahahaha looking for the screenshot of the expression in the Edit Expression window like below

Sorry, if I was not clear before

Best,

Sunny

Re: Show records

Anonymous — Thu, 02 Jul 2015 12:57:08 GMT

Sorry Sunny. What I was being stupid! Haha.

You'll be glad to know I have figured this out now! Hurray...

Thank you very much for your help it is much appreciated

Re: Show records

sunny_talwar — Thu, 02 Jul 2015 12:59:36 GMT

Awesome

I am glad you did, but would you be willing to share what were you doing wrong? May be someone else might benefit (in the future) from your response and won't make the same mistake

Best,

Sunny

Re: Show records

Anonymous — Tue, 07 Jul 2015 14:37:37 GMT

Hi Sunny,

I fixed this by adding one of my expressions as a dimension within the table. I was then able to suppress zero values on the table and this removed the unwanted date

Thanks again for your help. Wouldn't have been able to achieve this without this community