topic If in Apply Map? in QlikView

If in Apply Map?

qlikuser222 — Wed, 18 Apr 2018 19:47:59 GMT

hi Everyone,

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.

Thanks

sasiparupudi1 — Wed, 18 Apr 2018 20:00:05 GMT

Dont really get the logic behind your requirement but may be like this?

Test:

load * Inline [

ID, Stage, Desc

AAA, 9, Propose

AAA, 10, Flight

AAA, XXX, Implement

BBB, 9, Propose

BBB, 10, Flight];

Map_Stage:

Mapping Load

Stage,

Stage

Resident

Test;

Drop Table Test;

Test1:

Load

ID,

Stage_1,

Date,

Applymap('Map_Stage',Stage_1,If(Date<201731,9,10)) As Stage

inline [

ID,Stage_1, Date

AAA, XXX, 201731

BBB, YYY, 201731,

BBB, QQQ, 201810];

sasiparupudi1 — Fri, 20 Apr 2018 09:39:43 GMT

Did you manage to get this working?