Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

aveeeeeee7en
Not applicable

Apply Map Help

Hi Community

I need some changes. Please see the Attached qvw.

Regards

Aviral Nag

Tags (1)
3 Replies
chiru_thota
Not applicable

Re: Apply Map Help

See attached QVW. Just.Just I used set analysis.

I don't see any issue with your apply map.

Applymap.jpg

aveeeeeee7en
Not applicable

Re: Apply Map Help

Thanks for your reply.

But I need the logic from Back-end.

Not applicable

Re: Re: Apply Map Help

Hi ,

try this

 

AAA:

Mapping Load * Inline [
code, New
11 , BBB
12, SSS
]
;

AAA:
Load * Inline [
name, code, Dept
Ron , 11, aa
, 11, cc
John, 12, ss
, 13, cc
]
;

Res:
Load *,
name&code&Dept as Key,
Applymap('AAA',code,'NULL') AS New11
Resident AAA
Where name&code&Dept<>'11cc';

Drop Table AAA;

Drop Field Key;