Calculations in Script

Wed, 24 Dec 2014 11:05:58 GMT

I have done some statistical calcualtions on the dashboard as shown in the following two tables. However this is only a small portion of the original data and hence I get timely results. I want to replicate these calculations in the script and maybe create variables which can be called on the dashboard when the data size is large.

These are the four statistical measures that have been calculated:

Mean Absolute Deviation

Avg(Aggr(Fabs(Sum(Unit) - Avg(Total <Contract Unit)), Month, Contract )

Co-Efficent of Variation

(Stdev(aggr(sum(Unit),Month,Contract)))/(aggr(avg(total Unit),Account))

Std Deviation

Stdev(aggr(sum(Unit),Month,Contract))

Variance

sqr(Stdev(aggr(sum(Unit),Month,Contract)))

For each Contract these statistics have been calculated as follows:

The moving average is used where for each subsequent month the average of all previous data is used to calculate the average and then the deviation.

If there is a way to do these calculations in the script, please let me know! Thanks!

Re: Calculations in Script

Gysbert_Wassenaar — Wed, 24 Dec 2014 12:32:48 GMT

That should be possible. Can you post an example document that contains the data?

Re: Calculations in Script

Mon, 29 Dec 2014 04:44:56 GMT

Do you want me to post the source data file or the extracted data from Qlikview?

Re: Calculations in Script

Gysbert_Wassenaar — Mon, 29 Dec 2014 06:46:04 GMT

If you want to the calculations done in the script then the source data is needed.

topic Re: Calculations in Script in Qlik Learning Discussions

Calculations in Script

Re: Calculations in Script

Re: Calculations in Script

Re: Calculations in Script