I am relatively new to Qlik Sense.
I wanted to know how to use Vlookup in Qlik Sense. I have associated the two tables but am not finding a way to perform Vlookup.
I have attached the snippet of how my table is Modeled. I need the highlighted column of Num_Of_TS-Entries_per_day into a calculated column in Busyness table.
If anyone is familiar with Power Pivot, I am looking for a =RELATED() equivalent.
The data is already associate according to your data model, so you should be able to count the number of entries per day without changing your model.
If you do want to alter the model, the equivalent of VLookup is to use a "Mapping Load" and "ApplyMap" which you can add in your load script.
These posts relate to QlikView but the command syntax is identical.
Okay, newbie question I guess, I have to use applymap while loading right? I cant use it as a Calculated Field (which is what I actually want). This calculation has to take place after it is loaded.