Weekly growth in usage

[qlikviewforum]

Hi All,

I want to find the growth in Space from previous week to current week. Data is something like below. Can someone help me to create a chart for the same? Please help ASAP

ENV	Total Space	Used Space	Free Space	Date
DEV	50	32	18	03-11-2013
UAT	50	45	5	03-11-2013
PRD	50	23	27	03-11-2013
DEV	50	21	29	27-11-2013
UAT	50	45	5	27-11-2013
PRD	50	32	18	27-11-2013

[qlikviewforum]

Any update on this?

[Gysbert_Wassenaar]

See attached example.

[qlikviewforum]

I think you didn't attach it. Can you please attach it?

[qlikviewforum]

Variance Expression : (Sum(Qty) - before(Sum(Qty)))
Var% Expression: (Sum(Qty) - before(Sum(Qty)))/before(Sum(Qty))
----------------------
sum(Sales)/above(sum(Sales))-1
------------------------
(Sum({$<YEAR={$(=Max(YEAR(TranDate)))},MONTH={$(=Max(Month(TranDate)))}>}
Qty) /
Sum({$<YEAR={$(=Max(YEAR(TranDate))-1)},MONTH={$(=Max(MONTH(TranDate))-1)}>}
Qty))*100-100
----------------------
Growth_Percent = (Growth - above(Growth)) / above(Growth)
----------------------
Sum({$<Year={$(=Max(Year))}>} sales)
Sum({$<Year={$(=Max(Year)-1)}>} sales)