Discussion Board for collaboration on QlikView Scripting.
I need some changes. Please see the Attached qvw.
See attached QVW. Just.Just I used set analysis.
I don't see any issue with your apply map.
Thanks for your reply.
But I need the logic from Back-end.
Mapping Load * Inline [code, New11 , BBB12, SSS];AAA:Load * Inline [name, code, DeptRon , 11, aa, 11, ccJohn, 12, ss, 13, cc];Res:Load *,name&code&Dept as Key,Applymap('AAA',code,'NULL') AS New11Resident AAAWhere name&code&Dept<>'11cc';Drop Table AAA;Drop Field Key;