Caching the data in Qlikview/ Many expressions in QV document
Dear All,
What is the best approach to work with large & complex expressions? I am building a QV document with more than 50 different KPIs, So I wanted to build a robust model in place. I am looking for a simple approach to maintain the expressions...
Iassen - Thank you for quick response. I had already assigned variables for the common parts of the expressions for re-usability purposes. However, I am not sure about Pre-calculating the non-dynamic values. Inface I have almost 10 expressions which return deterministic/ Non-dynamic values. Please can you provide an example or sample script on how to integrate these functions in the load script?
It's hard to show a generic example, but say you have a few transactions, but you will never want to see them separately, and always summed up instead. Then you do a SUM in your loading script using the adequate GROUP BY and this way you end up with pre-aggregated values that you just use in your expressions and you don't need to do the SUM there, which uses both space and resources.
