Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
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

2 Replies
sasiparupudi1
Master III
Master III

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
Master III
Master III

Did you manage to get this working?