Discussion board where members can get started with Qlik Sense.
I am trying to keep all the calculations in my qlik sense report in the script itself so that i can increase the performance.
But can i directly use the calculation in the scrpt just like in the report without using any join statements if the fields in the expression comes from different physical tables?
Go to Solution.
No, LOAD statements (where you will use your aggregation functions) are working on a single input table.
There is no logical inference engine during script time, compared to your data model after the LOAD script has finished.
So you would need to use joins / mappings etc. to get all fields needed into the table where you want to calculate the measures.
To be more precise, there are few methods to access field values from a different resident table, like
A Look at the Lookup Function
But the performance will be notable worse compared to mapping the field values to the same table, except for very simple settings.
But will it be beneficial when compared to the calculations written within the report?
Sorry for the late answer: What do you mean with beneficial?
If you can put your calculations in the script, without limiting the user in her ability to dynamically explore the data, I would do it in the script.