Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

**URGENT**Multiple if else statement

Hi,

Can some one please help me writing this multiple if else statement

IF(Airport = 'N','Left',if(Type = 'A' AND [Race1] = 'FA',if(Race2 = 'RC' or 'RG','Right','Skip'))) as Type

Thanks!

1 Solution

Accepted Solutions
Not applicable
Author

Hope this helps.

IF(Airport = 'N', 'Left',

  if((Type = 'A' AND [Race1] = 'FA'),

  if((Race2 = 'RC' or Race2='RG'),'Right','Skip'))) as Type

View solution in original post

2 Replies
Not applicable
Author

Hope this helps.

IF(Airport = 'N', 'Left',

  if((Type = 'A' AND [Race1] = 'FA'),

  if((Race2 = 'RC' or Race2='RG'),'Right','Skip'))) as Type

Anonymous
Not applicable
Author

Thank you! You rock!