Writing expressions in a script instead of a chart
Hi,
I want to show sales data based on month. For that I have some expression in a stacked 100% bar chart.
count(Sales)/count(TOTAL <Month> Sales)
I was wondering if it is possible to move this expression to the script so that it is calcuated, stored and exported from the QVD and is not calculated at runtime by the QVS server. I tried pasting the script as it is but it gave an error 🙂
Reason: I am assuming this will save some processing time as I have around 100 such expressions in my QVW file.
In spite of processing time, that will mean you need to accumulate (or get accumulations from SQL statements) which is quite contrary to the use of QlikView. You may want to set that in a variable in the script and use it later in a chart, instead of writing the same expression several times.
The only way to avoid that being calculated in runtime is doing that aggregation in the script, so yes, you can load and group by. Anyway, unless you are experiencing severe performance issues not due to data modelling or calculated dimensions, or conditionals instead of set analysis, I wouldn't recommend this kind of aggregation.
Table:LOAD ID, Sum(Amount) AS AmountFROM File.qvd (qvd)GROUP BY ID;
Of course I don't know neither your model or your indicators, and the above may be the only way to get that working.
In spite of processing time, that will mean you need to accumulate (or get accumulations from SQL statements) which is quite contrary to the use of QlikView. You may want to set that in a variable in the script and use it later in a chart, instead of writing the same expression several times.
The only way to avoid that being calculated in runtime is doing that aggregation in the script, so yes, you can load and group by. Anyway, unless you are experiencing severe performance issues not due to data modelling or calculated dimensions, or conditionals instead of set analysis, I wouldn't recommend this kind of aggregation.
Table:LOAD ID, Sum(Amount) AS AmountFROM File.qvd (qvd)GROUP BY ID;
Of course I don't know neither your model or your indicators, and the above may be the only way to get that working.
That depends, because once you put it in the script it looses the option to be re-calculated based on your current selections and it becomes a static value. If that is OK with your application's logic, then comes the syntax, which will not be identical, because you don't have the TOTAL modifier in the script version of the SUM function. You will have to do the aggregate values based on the GROUP BY clause and have a few consecutive loads in order to work this logic.
.png "Miguel_Angel_Baeyens"){kind=avatar}
