Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

quick applymap example

Would someone upload a small example of how to use applymap?  I'd really appreciate it!

22 Replies
Sujit
Contributor
Contributor

in applymap() field, if null() is not quoted then what will be the o/p in case of no matching

jhupkens
Contributor
Contributor

Hi,

An additional question re. Applymap: it is clear how to use 2 columns just like the VLOOKUP function in Excel.

But what if I would like to add another column to the table?

Like this:

Column 1          item A               item B               item C

Column 2          value A             value A             value B

Column 3          descr. 1            descr. 2            descr. 3

 

Etc. with many more different possibilities.

How would the script look like?

Jesse

Sujit
Contributor
Contributor

in case you want corressponding values from 'n' fields(column) for any value, then you need yo apply 'n' mapping loads.