Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rupaliqlik
Creator
Creator

Nested if in qliksense

Hi Folks,

 

I want to write a logic in qliksense application for IsRetailerMapped field but I am not getting multiple case when condition.Please help me to convert below code in qliksene.

rupaliqlik_0-1647490199754.png

@sunny_talwar 

 

Thanks,

Rupali

 

Labels (1)
1 Reply
rupaliqlik
Creator
Creator
Author

If(BusinessUnitId=1,
IF(Match(IsRetailerMappedCP,0) or isnull(IsRetailerMappedCP),
IF(isnull(IsRetailerMapped),'No',
If(IsRetailerMapped=1 or IsRetailerMappedCP=1,'Yes', 'No'))),
If(BusinessUnitId=2,
IF(Match(IsRetailerMappedVeg,0) or isnull(IsRetailerMappedVeg),
IF(isnull(IsRetailerMapped),'No',
If(IsRetailerMapped=1 or IsRetailerMappedVeg=1,'Yes', 'No'))),
If(BusinessUnitId=3,
IF(Match(IsRetailerMappedFC,0) or isnull(IsRetailerMappedFC),
IF(isnull(IsRetailerMapped),'No',
If(IsRetailerMapped=1 or IsRetailerMappedFC=1,'Yes', 'No')))))) as IsRetailerMapped_New

 

this is failing to give data