Discussion Board for collaboration on QlikView Scripting.
i have a requirement where we have to use if in apply map condition's.
Please find attached where i described the code. Please help me with understanding the logic.
Dont really get the logic behind your requirement but may be like this?
load * Inline [
ID, Stage, Desc
AAA, 9, Propose
AAA, 10, Flight
AAA, XXX, Implement
BBB, 9, Propose
BBB, 10, Flight];
Drop Table Test;
Applymap('Map_Stage',Stage_1,If(Date<201731,9,10)) As Stage
AAA, XXX, 201731
BBB, YYY, 201731,
BBB, QQQ, 201810];
Did you manage to get this working?