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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
Power
Contributor
Contributor

excel logics to qlik sense script

Hello,

I would like to understand, e.g., how to script this excel logic into Qlik sense script:

=IF([@Task]="abc";"def";vlookup([@disc];GENERAL_Disc[#All];GENERAL_Disc!B$1;FALSE));"")

I have been lookin to functions like 'mapping load' and but i am struggling to find the proper way to add complex calculated fields (using columns from different tables) to the existing table structure.

 Can someone help me solve the example and maybe suggest some best practice for these kind of issues?

The goal is to bring the 'computational weight' in cloud so that the data workflow would benefit.

Any help would be much appreciated, thanks!

Labels (2)
0 Replies