Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Thanks but this looks like Qlik View, I need it for Qlik Sense.
I guess you need Applymap(). Explore this function from Help: ApplyMap - script function ‒ Qlik Sense
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.
Hi Siddharth,
You can make use of applymap() or Lookup(). You can even check out Left Keep() which ever fits your cause best.
Thanks,
Sangram.
No, does not help. Anyways, I found a work around. Thanks guys.
Applymap is used in the script when loading data, it cannot be used as a chart expression.
Also looks like I cannot use Applymap if I have more than 2 columns.