Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

If statemenet

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

1 Solution

Accepted Solutions
Not applicable

Re: If statemenet

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

i will try to explain a bit better, 

Thanks Anand Chouhan & Agis Kalogiannis

4 Replies
alk
Not applicable

Re: If statemenet

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
Not applicable

Re: If statemenet

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

Not applicable

Re: If statemenet

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

i will try to explain a bit better, 

Thanks Anand Chouhan & Agis Kalogiannis

Not applicable

Re: If statemenet

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

Community Browser