topic Re: Average Change per 10 week in QlikView

Average Change per 10 week

padmanabhan_ram — Tue, 19 Jul 2016 12:13:42 GMT

Dear All,

I am trying to get the value of Average Change per 10 week. Please find the attached qvw and excel sheet with Sheet name 'Data' which contains sample date to load into QlikView and Sheet 'Expected calculation', the Cell 'Calculated Slope' is the expected output in the QlikView for 'Average change per 10 week' column.

Looking for your response. Thank you.

Br,

Padmanabhan

Re: Average Change per 10 week

Gysbert_Wassenaar — Tue, 19 Jul 2016 12:42:16 GMT

Calculate the difference between weeks for each region in the script:

Temp:

LOAD

Region,

Week,

Volume

FROM

excelfile

;

Result:

LOAD

Region,

Week,

Volume,

If(Region=Previous(Region),Volume-Previous(Volume)) as Change

RESIDENT

Temp

ORDER BY

Region, Week

;

DROP TABLE Temp;

Then calculate the average in the chart with the expression Avg(Change).

Re: Average Change per 10 week

Tue, 19 Jul 2016 12:58:03 GMT

Hi,

check this.Hope this helps.

Thanks.

Re: Average Change per 10 week

padmanabhan_ram — Tue, 19 Jul 2016 14:19:22 GMT

Dear Gysbert,

Thank you for the response. But when i try to apply the same logic for bigger size of data the output doesn't match.

Please find the attached data, where the output for 'Average change per 13 week' should be 28 for the below selections.

Area='South', Product='A'.

could you please help me to find this out.

Br,

Padmanabhan

Re: Average Change per 10 week

kamielrajaram — Tue, 19 Jul 2016 15:10:31 GMT

Hi,

Hope this helps or leads you in the right direction.

Regards

Kamiel

Re: Average Change per 10 week

Gysbert_Wassenaar — Tue, 19 Jul 2016 15:34:42 GMT

Try as AsOf table: Calculating rolling n-period totals, averages or other aggregations

Re: Average Change per 10 week

padmanabhan_ram — Wed, 20 Jul 2016 06:11:02 GMT

Hi Kamiel,

Thank you for the reponse.

if I apply the same logic with large data then the output doesn't match.

Please find the attached data for which I am trying to get the Average change per 13 week = 28 for South Area, product =A.

Please let me know if you get the same value or near to that.

Br,

Padmanabhan