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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
rupaliqlik
Partner - Creator
Partner - 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
Partner - Creator
Partner - 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