Help required to frame the logic in QlikView.

qlikviewforum — Wed, 12 Nov 2014 06:47:36 GMT

Hi,

I need help your to frame the below logic.

If(ApplyMap('PRDIDFLAG',PRDID,'NA') <>’NA’, Product,’Apply Below Logic’)

If the match is found in the above applymap then we have SET the flag as Product. For rest of the records we have to apply below logic and find out whether it is Product or Non-Product. Can some help me out to frame this logic in QlikView?

-----

([Flag] = 'Y'
,'Product'
,
if([Flag] = 'N' and ApplyMap('PRDIDCHECK',PRDID,'NA') = 'NA'
,'Product'
,
if([Flag] = 'N' and ApplyMap('PRDIDCHECK', PRDID,'NA') <> 'NA'
,if(ApplyMap('PRDIDCHECK', PRDID,'NA') = 'Y','Product','Non-Product')
,
if([Flag] = 'N' and ApplyMap('PRDIDCHECK', ORG_PRDID,'NA') = 'NA'
,'Product'
,
if([Flag] = 'N' and ApplyMap('PRDIDCHECK', ORG_PRDID,'NA') <> 'NA'
,if(ApplyMap('PRDIDCHECK', ORG_PRDID ,'NA') = 'Y','Product','Non-Product')
,'Non-Product')))))
as

[Product Flag]

-----

topic Help required to frame the logic in QlikView. in QlikView

Help required to frame the logic in QlikView.