topic Re: if formula in QlikView

if formula

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

Hi,

I have a standard table for quotations (based on article codes) with columns quotation price and minimum price.

I have made a formula in dimension of quotation price that turns background colour of quotation price red if

quotation price < minimum price

=if ((offerteregel_prijs < [minimale verkoopprijs]) , red(150))

But there are article codes that do have a quotationprice, but don't have a minimumprice (there is no value) In that case the background of the quotation price should also turn red.

I have tried it with this formula:

=if ((offerteregel_prijs < [minimale verkoopprijs]) or [minimale verkoopprijs] = '0', red(150))

In the presentation of the table I marked 'null-symbol" as: 0

But this does not seem to work.

Any one of you, who can help me out with this?

Re: if formula

isingh30 — Tue, 22 May 2018 14:04:50 GMT

May be this -

if ('offerteregel_prijs'< 'minimale verkoopprijs' or 'minimale verkoopprijs' = 0, red(150))

Thank you!

Re: if formula

isingh30 — Tue, 22 May 2018 14:06:40 GMT

You are doing this in the background color under dimensions?

Re: if formula

olivierrobin — Tue, 22 May 2018 14:09:56 GMT

hello

try to add

or isnull(minimumprice)

to your condition

Re: if formula

sunny_talwar — Tue, 22 May 2018 14:22:43 GMT

Try this

=If(offerteregel_prijs < [minimale verkoopprijs] or Len(Trim([minimale verkoopprijs])) = 0, Red(150))

Re: if formula

anitamanders — Wed, 23 May 2018 07:25:23 GMT

yes

Re: if formula

anitamanders — Wed, 23 May 2018 07:25:44 GMT

Thank you, this works fine !