topic Re: monthtodate compared with previous year the same period in QlikView

monthtodate compared with previous year the same period

Tue, 17 Sep 2013 21:03:07 GMT

hi all,

how can i do a formula for this situation(or another solution for this)?

the source is something like this:

Date Value Salesman

9/1/2012 2 George

9/2/2012 12 Luisa

....

9/30/2012 4 Luisa

...

9/1/2013 6 Alex

9/2/2013 19 Mary

and i want to make a straight table like this in which i want to compare month to date with the same period in previous year

Salesman Value 2013 Value 2012

George sum({<Year=2013>}Value) ...1-2 sep sum({<Year=2012>}Value) 1-2 sep

Luisa

Alex

Mary

thanks a lot

Re: monthtodate compared with previous year the same period

Gysbert_Wassenaar — Wed, 18 Sep 2013 11:14:17 GMT

You need to create a Year field in the script using the Date field:

Load

Date,

Year(Date) as Year,

Value,

Salesman

From ...mysource...;

Once you have that year field you can use the set analysis expressions you posted above. It sounds like you want to select a month. In that case you also need a Month field: Month(Date) as Month

If you need more help please post an example document with sample data.

Re: monthtodate compared with previous year the same period

Wed, 18 Sep 2013 11:29:20 GMT

Hi,

PFA

Re: monthtodate compared with previous year the same period

Wed, 18 Sep 2013 11:57:09 GMT

suppose that i have data until yesterday and every day the source will be updated with last day

so i want to compare 1-17 sep 2013 vs 1-17 sep 2012; tomorrow i want to apear a calculation like 1-18 sep 2013 vs 2012 and so on

thanks all of you

Re: monthtodate compared with previous year the same period

Wed, 18 Sep 2013 12:06:09 GMT

so the problem is how do i create a formula to calculate for the same period last year depending by this year

Re: monthtodate compared with previous year the same period

Wed, 18 Sep 2013 12:10:55 GMT

hi,

thanks for your help; i commented on the bottom my problem; i want to calculate automatically last year the same period

1-17 sep 2013 vs 1-17 sep 2012 not all sep 2012

thanks