Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks,
Rupali
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