Discussion Board for collaboration on QlikView Scripting.
I am Stuck at one point in Scripting..
Want to merge two field but issue is this max of one field on the basis of group with another field.
WHat I did:
In OLD QVD: I have group and old_grp and IN NEW QVD I have group and new_grp
I concatenate both the QVD but I didn't the Output as I want.
OUTPUT as I want
Please help me out..
'Old' as Flag
(html, codepage is 1252, embedded labels, table is @1);
'New' as Flag
(html, codepage is 1252, embedded labels, table is @2);
If(Group = Previous(Group) and Flag = 'New', RangeSum(Peek('old_grp'), 1), old_grp) as old_grp,
Order By Group, Flag desc, old_grp;
DROP Table Table;
a small change
If(Group = Previous(Group) and Flag = 'New',
//RangeSum(Peek('old_grp'), 1), old_grp) as old_grp,
Date(AddMonths(Date#(Peek('old_grp') & '01', 'YYYYMMDD'), 1), 'YYYYMM'),
old_grp) as old_grp,
here in the image you can see its showing the same as earlier ..that script doesn't work correctly..
Showing 2016-5 flag1-> new output_grp ->12301 ..instead of 12314
Would you be able to share this application where you tried this out?