topic Re: How to calculate the evolution of a given week over same week of the previous year in QlikView

How to calculate the evolution of a given week over same week of the previous year

Tue, 22 Sep 2015 21:47:32 GMT

Hello all

I worked with qlikview some years ago but I'm stuck with the calculation of evolution calculation

I m working with week at the following format: YYYY/WW

I prepared the following sample (which is a simplified example of the dataset I use everyday:

My problem is that I want to calculate and plot the evolution of Volume or TO vs previous year

I tried using a set analysis with variable Year = Year-1 or Week_N = Week_N - 52 (Week_N, is used to number the week from 2012)

In my chart X axis is DATE_S

Here below, the formulas I tried:

=sum(Volume) / Sum({$ <Year ={$(=Year-1)}> } Volume)

=sum(Volume) / Sum({$ <Year ={$(=vYearM1)}> } Volume) where vYearM1 = Year -1

I tried the same with Week_N - 52 .. but it doesn't work anymore,

Thanks all for your help

Jonathan

Gysbert_Wassenaar — Wed, 23 Sep 2015 09:08:21 GMT

See attached example.

Wed, 23 Sep 2015 10:51:05 GMT

I can't see the attached file ?

Gysbert_Wassenaar — Wed, 23 Sep 2015 10:59:10 GMT

I can:

Try again. If you still can't see it we'll mention the issue to the administrators.

Wed, 23 Sep 2015 12:06:29 GMT

it's ok, I was just in my notification where I can read the answer but where I con't see Attached file. Thank you! I will look at it.