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: 
nicouek
Creator
Creator

Qlik function

Good morning all

I want to kindly ask, why would I rather use an ApplyMap function if I can just associate the inline table on the field with the same name and values?

Is it best practice?

Are there negative ramifications to just using an association vs the function? 

Than you

Labels (1)
5 Replies
JHuis
Creator III
Creator III

Hello 

 

Apply map is that you get data from an QVD file, it is more or less Vlookup in Excel. I use it if i want to put an extra field from a qvd to another qvd file.

 

An inline table is just an table that you could add and write your own table. 

 

So what is is your use case? 

nicouek
Creator
Creator
Author

Hello JHuis

I am using the inline table as  a VLOOKUP with QVD tables in my data model, and it's working fine. However if I understand what you are saying, you use the ApplyMap to ADD fields from an existing QVD to another table vs creating a whole new table in the data model via an Inline...? Correct me if I did not understand...

Thank you

JHuis
Creator III
Creator III

Hello.

 

Yes this is correct. if you are searching for VLookup in Qliksense apply map is the way to go. With multiple fields joining is better. 

marcus_sommer

Mapping isn't restricted to qvd-loads else could be applied by each kind of loads. Further it's not only usable to add fields else also to check and manipulate data. It's simple, fast and without risks to change the number of records - as joins would do. So a lot of possibilities ...

E_Røse
Creator II
Creator II

With applymap, you can specify a default value which will be used  if the mapping table does not contain a matching value. 

So if there is a chance that the field you wanted to map at a a later time may have values that are unknown to you now (and your lookup table is not automatically updated as well), then applymap is better.