Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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