Help required to frame the logic in QlikView.

[qlikviewforum]

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?

-----

if

([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]

-----