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?
It depends on your calculations. You can use Peek() to lookup values in other tables so you can combine fields across tables. Still it might be cumbersome to do the right calculations without resorting to joins - it all depends.
