Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

If in Apply Map?

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

Tags (2)
2 Replies
Highlighted
Master III
Master III

Re: If in Apply Map?

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];

Highlighted
Master III
Master III

Re: If in Apply Map?

Did you manage to get this working?