Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
lornafnb
Valued Contributor

Nested Applymap

hi guys

In this nested applymap I am checking if a ucn exists in SEGMENT_MAP_PREMIUM. If not check for SEGMENT_MAP_EASY, if not look in SEGMENT_MAP_GOLD.

If a person does not exist in ANY of these I want to display 'Not Found', otherwise I want to display the result of the Applymap

I seem to have a syntax error here...please assist

if(ApplyMap('SEGMENT_MAP_PREMIUM',AutoNumberHash256(ucn & '|' & PERIOD),'No Match' = 'No Match',

     if(ApplyMap('SEGMENT_MAP_EASY',ucn),'No Match' = 'No Match',

         if(ApplyMap('SEGMENT_MAP_GOLD',ucn),'No Match' = 'No Match','No Match'))) as Segment2

thank you

1 Solution

Accepted Solutions
atoz1158
Contributor

Re: Nested Applymap

Hi

Try the following

ApplyMap('SEGMENT_MAP_PREMIUM',AutoNumberHash256(ucn & '|' & PERIOD),

     ApplyMap('SEGMENT_MAP_EASY',ucn,

          ApplyMap('SEGMENT_MAP_GOLD',ucn,'No Match'))) as Segment2

You do not need the if statement because ApplyMap acts like and if state statement itself.

Adrain

2 Replies
atoz1158
Contributor

Re: Nested Applymap

Hi

Try the following

ApplyMap('SEGMENT_MAP_PREMIUM',AutoNumberHash256(ucn & '|' & PERIOD),

     ApplyMap('SEGMENT_MAP_EASY',ucn,

          ApplyMap('SEGMENT_MAP_GOLD',ucn,'No Match'))) as Segment2

You do not need the if statement because ApplyMap acts like and if state statement itself.

Adrain

lornafnb
Valued Contributor

Re: Nested Applymap

Brilliant thank you

Community Browser