topic Quarter over quarter sales analysis in QlikView

Quarter over quarter sales analysis

timmy — Thu, 19 Aug 2010 09:15:56 GMT

Hi,

I need a Quarter over quarter sales on a rolling 3 quarter period and within a period regardless of a calendar selection for example selecting the 2nd month in Q1 will compare the 2de month in the preceding quarters.

how can i fix this chart because i have no clue with the months...

tnx

Quarter over quarter sales analysis

Thu, 19 Aug 2010 09:34:26 GMT

See the example attached.

Quarter over quarter sales analysis

Thu, 19 Aug 2010 10:25:06 GMT

Probably this will suit you more.

Quarter over quarter sales analysis

timmy — Thu, 19 Aug 2010 11:43:52 GMT

Tnx

Still one question. How can you let this work over the years. So if you select nothing it takes the max year and compare the last 3 Quarter but if you select 2010-Q1 the preceeding quarters are 2009-Q4 and 2009-Q3.

how can you fix this?

AW:Re: Quarter over quarter sales analysis

volcore79 — Wed, 09 Feb 2011 20:57:23 GMT

Did you solve the Problem ? I have the same one..

Quarter over quarter sales analysis

Wed, 09 Feb 2011 22:04:49 GMT

Hi,

You need a MonthYear field and the expression should be something like this.

sum({$<MonthYear={

">$(#=monthname(max(MonthYear),-9))<=$(#=monthname(max(MonthYear)))"},Year=,Quarter=,Month=>} Sales)

Hope this helps

Quarter over quarter sales analysis

Thu, 10 Feb 2011 06:40:13 GMT

Hi Morales,

Could you pls attach the sample file...

bcoz, i m also having the same problem.....

thanx in advance......

AW:Re: Quarter over quarter sales analysis

volcore79 — Thu, 10 Feb 2011 09:39:37 GMT

Nop, this doesn't really help. Could you attach an example file ?

Quarter over quarter sales analysis

lironbaram — Thu, 10 Feb 2011 10:25:54 GMT

hei

attach is an exmaple of what you asked for

what i add to the file is

a monthyear filed which holds the start date of the month,

two variables who claculate the max monthYear and min to be showed

the i put a little set analysis in the expression

the secret to handle the change between years is using the addmonths function which can add or substract the desiered amount of months from a certien date

hope it helps you

Quarter over quarter sales analysis

amien — Sun, 06 Mar 2011 09:12:23 GMT

great stuff riouser. . thanks

Quarter over quarter sales analysis

Tue, 08 Mar 2011 12:41:31 GMT

Hi..

I would like to select the month field....

what are the changes i have to do....

thanks in advance...

Re: Quarter over quarter sales analysis

Mon, 17 Jun 2013 09:17:33 GMT

hey santosh can u share code for it ..as i cant open this qvw