topic week to week differense calculation in QlikView

week to week differense calculation

Thu, 27 Mar 2014 07:10:21 GMT

Hi everybody! Explored many topics with similar or alike titles but didn't find right solution. The problem is to calculate the difference between weeks in straight table. In most topics have been discussed there is a selection of 2 definite periods (usualy year to year). In my case I select 1 period (e.g. January 2014) and have to get such table

Week	Sales	Growth
1	100	0
2	150	50
3	120	-30
4	160	40

So the problem is,that I can't compute the difference between weeks in 1 month.

I tried formula like this:

= sum({$}Sales) - sum({$<Week={Week-1}>}Sales), but it didn't work. Week numbers are in my calendar. I feel that solution is simple,but can't find it. Can anybody help me?

Re: week to week differense calculation

MK_QSL — Thu, 27 Mar 2014 07:27:33 GMT

Sales

SUM(Sales)

Growth

SUM(Sales)-Above(SUM(<Month>Sales)

SUM(Sales)-Above(SUM(Sales)

Re: week to week differense calculation

PradeepReddy — Thu, 27 Mar 2014 07:28:23 GMT

As per my understanding...

sum(Sales)-above(sum(Sales))

Re: week to week differense calculation

Thu, 27 Mar 2014 07:38:06 GMT

This way also was tried. But functions above() and before() can be used only in charts ot pivot tables

Re: week to week differense calculation

Thu, 27 Mar 2014 09:16:44 GMT

Мy apologies! Guys, it works! Thanks a lot!