topic Re: Why one condition work when add one more condition it return wrong value ? in QlikView

Why one condition work when add one more condition it return wrong value ?

paulyeo11 — Thu, 18 Jan 2018 03:12:57 GMT

Hi All

My expression below work fine :-

sum(if([Sales Stage]='Sales_Fulfillment',(Amount)))

But when i want to add one more condition , it does not give the correct result :-

sum(if([Sales Stage]='Closed_Won' or 'Sales_Fulfillment',(Amount)))

if i use and , it does not display any value. ( below expression is wrong , so cannot use and )

sum(if([Sales Stage]='Closed_Won' and 'Sales_Fulfillment',(Amount)))

May i know where go wrong ?

Paul Yeo

paulyeo11 — Thu, 18 Jan 2018 03:13:43 GMT

my QVW

kenphamvn — Thu, 18 Jan 2018 03:22:10 GMT

Try this

sum({<[Sales Stage] ={'Closed_Won','Sales_Fulfillment'} >} Amount)

Regards

An Pham

paulyeo11 — Thu, 18 Jan 2018 03:27:50 GMT

Hi An Pham

Thank you

So it is possible to use if instead of SET ?

Paul

kenphamvn — Thu, 18 Jan 2018 03:39:01 GMT

Yes

you can using If statement instead SET

sum(if([Sales Stage]='Closed_Won' or [Sales Stage] ='Sales_Fulfillment',(Amount)))

Regards

An Pham

paulyeo11 — Thu, 18 Jan 2018 03:57:54 GMT

Hi Pham

Thank you very much , now i know where i make the mistake

Paul