Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
New Contributor III

Trouble with If Statement

Hi, Im having an issue with an if statement in an expression. If the dollar amount of a dimension is $0, I want that to enter "Placed", "Order" if there is a dollar amount populated. The below expression is not working for me.

=if(

{$<

[Amount - Shipped/Fulfilled USD]-={'$0.00'}

>}

'Order','Placed ')

Thanks!

1 Solution

Accepted Solutions

Re: Trouble with If Statement

May be this

If([Amount - Shipped/Fulfilled USD] = 0, 'Placed', 'Order')

2 Replies

Re: Trouble with If Statement

May be this

If([Amount - Shipped/Fulfilled USD] = 0, 'Placed', 'Order')

danielco223
New Contributor III

Re: Trouble with If Statement

Thank you!

Community Browser