I am currently in the process of deciding what the most efficient way to code a chart is.
It will be a line chart showing values at 6, 12 and 24 months versus closure. Now rather than creating 3 separate charts to cater for each required expression, I've decided to create one chart and let the user choose which calculation to view.
I understand there are two ways to achieve this:
1) Create an island table with the three "numerators" as values, then code an if statement in the expression of the chart to perform the correct calculation depending on the value selected from the island table
2) Use text objects with set variable actions behind them, assigning the relevant "numerator" to a variable and using that variable in the expression
What I want to know is which is the preferred/most efficient approach? Has anyone done any comparisons on the efficiency of both approaches? Is there any other approach that I haven't consider?
Appologies if I haven't made myself particularly clear.
Hi, I don't know your model in detail but I would avoid creating extract tables which are not directly related to the model. Unless you have detailed data and you'd like to do (for any reason) a graph with aggregated data and it's to heavy to handle by Qlikview (maybe you don't have enough memory and prefer to show the values pre-aggregated).
I would keep my model as simpler as possible. This are trickts that can be easily handle by QlikView and I would go with your second option.
