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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
claudialet
Contributor III
Contributor III

Can multiple Nested If statements with 'Or' condition work ?

 Here is my expression with conditions : 

The result  I want is 

If A then A,

If B then B  but if B is not met then

If C then C 

 


if($(vFilter)=1 and DomesticFlag=1 , CompanyCode &' '&  Company Name ,

if($(vFilter)=4 and  ForeignFlag=1,  CompanyCode &' '&  Company Name,    << if  ForeignFlag=1 is not available  I want the next condition>>

if($(vFilter)=4 and StateFlag=1,  CompanyCode &' '&  Company Name

 

)) )

 

Is this correctly written ?

0 Replies