Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

4 Replies
Agis-Kalogiannis
Employee
Employee

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

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
Author

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
Author

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