Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

expression error

Hello All,

with below expression "OR" condition not working for me. If I enable one line its working fine but with multiple conditions not working for me as expected. kindly sugggest me.

//if(GetSelectedCount(Flagging)=1 and Flagging='Card Services',0,1)or
//if(GetSelectedCount(Flagging)=1 and Flagging='Chase Auto',0,1)or
//if(GetSelectedCount(Flagging)=1 and Flagging='BCC',0,1)or
//if(GetSelectedCount(Flagging)=1 and Flagging='Business Banking',0,1)or
//if(GetSelectedCount(Flagging)=1 and Flagging='Card Services' ,0,1)or
//if(GetSelectedCount(Flagging)=1 and Flagging='CCB Ops' ,0,1)or
//if(GetSelectedCount(Flagging)=1 and Flagging='Consumer Banking',0,1)or
//if(GetSelectedCount(Flagging)=1 and Flagging='Digital',0,1)

 

Thanks and Regards,

Navin

1 Reply
Wlad_Masi
Employee
Employee

Have you tried to use the or inside of the else condition?

Something similar to this: 

if(GetSelectedCount(Flagging)=1 and Flagging='Card Services',0,(if(GetSelectedCount(Flagging)=1 and Flagging='Chase Auto',0,1))

The way you are using your expression it will either be 0 or 1 in the first part what will never trigger the second expression aft OR.
If you embed one expression inside of the other you are saying that if the condition is not true, the second condition will be evaluated.

I hope it makes sense.
Please let me know if it helps you and if your problem was solved.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.