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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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