difference between



(2) Top 20 QlikView Interview Questions And Answers | Latest QlikView Interview Questions 2022 - YouTube


 1.

Lookup and Applymap

Applymap we will not have table in data model like lookup, so reduce size of data

when huge data there, applymap will be fast than lookup

Applymap function is easy to use and understand. 4 vs 3 parameters

In Applymap we have 2 required parameter, there is one more parameter which will substitute when matching value is missing.

2. Let and Set

Set just substitute the string eg '3+4' ='3+4'

Let validates the expression and substitutes the value. eg '3+4' = 7





 


Comments

Post a Comment

Popular posts from this blog

Section Access

Section access is similar to reduction, but is done by the QlikView Server when a user accesses the document. The choice between section access and static reduction is a question of performance and memory usage. When QlikView Publisher opens a section access protected QlikView file, the file is reduced based on the reduction values Table Columns The following table columns are available: ACCESS, a field that defines what access the corresponding user should have. The following options are available in the drop-down list: l ADMIN 2 USER OMIT, a field that should contain the field that should be omitted for this specific user. Wildcards may be used and the field may be empty. A facile way of doing this is to use a sub field.
Read more

Binary Load

Advantages: Really FAST You can hide script from users. You can load a whole model with only one line of code Section Access also transferred Cons: Lack of flexibility Can load only one model Binary load is used only for one application means you are able to read data from only one QVW application and on the above of the set scripts is a restriction. should be done at the begining It does not load the layout information or variables you can load variables into a table in the source document and then retrieve them from the table (using peek()) in the target document. You could use an include file to hold the variable definitions and then call the include file in both QVWS.
Read more