Hi all, I am replacing some Joins with ApplyMap() and (potentially) Lookup() in a Qlik Sense script. Two questions: I know ApplyMap() is faster than Lookup() and joining, but is Lookup() faster t...
Hello,
I have this table as mapping
map: LOAD * INLINE [ lookup, substitute -, 0 +, 1 ];
and this table with data
[data_loaded]:
LOAD
ASSY as Assy, //
&n...
Hello, I have a problem with Applymap function. After loading the script, lot of results are wrong. I don't have the same problem with a LEFT JOIN or lookup() but number of data is huge and t...
Hi, I am looking for a function similar to VLookup with the Setting to return the value to the closest number, as the Input Parameter is not given at all. ApplyMap or Lookup just searches for t...
...atches with that of a stock item and it works fine. if(isnull(Lookup('MATRL_DESC','MATRL_DESC',MR_DTL_MATRL_DESC,'Materials')),0,1) AS MR_DTL_IS_MATRL, Since ApplyMap is faster than Lookup, i'm t...
...apping table without a matching key (lookup value) which in the case of Category_Map would be ProductCategoryID, while SubCategory_CategoryMap wants to retrieve CategoryName using&n...
Hi All, I am in need of a solution similar to the lookup()script function, but for charts. Pretty much like Excel VLookup. I have a Sales Fact table and two dimension tables, Customers and P...
I am clueless as to how to go about this. In short, I need to determine if a patient's primary office is one that their doctor has worked at.
Here is more detail:
On any given patient's pro...
