topic Week on Week trend chart in QlikView

Week on Week trend chart

Thu, 30 May 2013 13:48:43 GMT

Hi,

I am looking to create a trended chart which shows weekly sales and the % Change of sales Week on Week.

I can't figure out how to create my second measure which is offset by a week.

i've attached what i am trying to do using Excel.

hopefully someone can help

thanks

Gysbert_Wassenaar — Thu, 30 May 2013 14:16:25 GMT

See attached example.

Thu, 30 May 2013 14:36:55 GMT

That looks pretty awesome, but it looks like you just loaded up some data that was already flagged as previous week.

what i need is a way of working out the previous week on the fly.

so this week is: sum(sales)

previous week, something like: sum(<offset(week-1)> sales)

but i have no idea on the syntax. Any ideas?

Thu, 30 May 2013 14:51:25 GMT

Legend! Thank you sir!

Thu, 30 May 2013 15:09:13 GMT

actually not 100% correct i am afraid....so close!

Functionally it works, but the first x days are not filled out.

so, if the function is above(sum(sales),7) at the day level the first 7 days are blank. This is true when you start drilling into the chart too.

attached is the original sample but with the functions added. you can see the first slot in the chart is always blank.