week over week growth rate

[#1]

Hi,

has someone an idea how can I calculate the week over week growth rate in Qlikview? I am attaching the qlikview figures I´ve imported.

The correct value for June/2 should be -1,2% which is calculated as the revenue from June/2 divided by  the value of the previous week, May/25 minus 1 multiplied by 100.

WoW growth  = (165/167-1)*100 = 1,2%

Any help would be highly appreciated!

Thanks,
David

[swuehl · Accepted solution]

Maybe like attached, using a join in the script to prepare your week over week comparison.

[#3]

it works! thanks a lot

david