multiple if condition in qliksense

[yogitamehta10]

i have a  expression in qlik.

if([Connection Type]='G','C'and match([Status],'A','Rejected')and match([MOSL REF ID],'MPS3A')>0 ,[MOSL REF ID])

[Gysbert_Wassenaar]

Perhaps you mean this:

if(Match([Connection Type],'G','C') and match([Status],'A','Rejected') and match([MOSL REF ID],'MPS3A')>0 ,[MOSL REF ID])

If not the please explain what the conditions are and what the different branches of the if statement are.

[sunny_talwar]

What are you trying to do?

1)

if([Connection Type]='G','C'

This isn't right, I guess use Match here as well. And also

2) match([MOSL REF ID],'MPS3A')>0

will return 0 or -1 and in your case both the condition will never meet because you have > 0. What are you trying to do here?

[yogitamehta10]

if(Match([Connection Type]='GS','CU')and match([Status],'Accepted','Rejected') and match([REF ID],'MPS3A'),[REF ID])

now check ?/

[yogitamehta10]

if(Match([Connection Type]='GS','CU')and match([Status],'Accepted','Rejected') and match([REF ID],'MPS3A'),[REF ID])

now  it is showing   blank

[sunny_talwar]

You still have an extra = sign. Try this:

If(Match([Connection Type], 'GS', 'CU') and Match([Status], 'Accepted', 'Rejected') and Match([REF ID],'MPS3A'), [REF ID])