topic Re: Re: Apply Map Help in QlikView

Apply Map Help

aveeeeeee7en — Thu, 27 Mar 2014 20:29:07 GMT

Hi Community

I need some changes. Please see the Attached qvw.

Regards

Aviral Nag

Re: Apply Map Help

chiru_thota — Thu, 27 Mar 2014 22:02:11 GMT

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

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

Re: Apply Map Help

aveeeeeee7en — Fri, 28 Mar 2014 03:56:56 GMT

Thanks for your reply.

But I need the logic from Back-end.

Re: Re: Apply Map Help

Fri, 28 Mar 2014 05:20:17 GMT

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;