Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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