topic Re: Weekly growth in usage in QlikView

Weekly growth in usage

qlikviewforum — Wed, 06 Nov 2013 04:43:03 GMT

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

Re: Weekly growth in usage

qlikviewforum — Wed, 06 Nov 2013 10:21:22 GMT

Any update on this?

Re: Weekly growth in usage

Gysbert_Wassenaar — Wed, 06 Nov 2013 11:42:06 GMT

See attached example.

Re: Weekly growth in usage

qlikviewforum — Wed, 06 Nov 2013 12:43:15 GMT

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

Re: Weekly growth in usage

qlikviewforum — Thu, 07 Nov 2013 06:24:50 GMT

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)