topic If statemenet in Qlik Learning Discussions

If statemenet

Fri, 20 Feb 2015 13:34:34 GMT

How would I put this into an IF statement but I have an IF statement already so I need an IF with an IF.

If ( If =left([PV_Case.Quote No_],8) = [PV_Case.Sales Order No_] , not converted, else converted.)

Regards

Tyrone

Agis-Kalogiannis — Fri, 20 Feb 2015 22:21:22 GMT

You can definitely use nested if statements or expressions.

I cannot see where the problem is...

Could you please give use some more information?

its_anandrjs — Sat, 21 Feb 2015 07:38:55 GMT

Hi,

Please elaborate more or you can try this

If( [PV_Case.Sales Order No_] = left([PV_Case.Quote No_],8) , not converted, else converted.)

Regards

Anand

Sun, 22 Feb 2015 15:00:53 GMT

Great that's what i was after i will test at work tomorrow.

i will try to explain a bit better,

Mon, 23 Feb 2015 10:33:29 GMT

if([PV_Case.Sales Order No_] = left([PV_Case.Quote No_],8) , 'Not Converted', 'Converted') as [PV_Case.Conversion_Status],

the statment now works and i have placed it into the script. how do i add a distinct into the expression?

Regards

Tyrone