Quarter over Quarter Sales comparison

[Anonymous]

Hi folks,

I have following requirment.

Quarter over quarter Sales on a rolling 3 quarter period and within a period regardless of a calendar selection i.e. selecting the 2^nd month in Q1 will compare the 2^nd month in the preceding quarters.

Thanks in Advance.......

[mjayachandran]

Check this

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd

[Anonymous]

thanks for ur time..... can i have expressions for how to compare Q1 2009 to Q4 2008....

[tresesco]

This type of analysis majorly depends on date/quarter field data type/format (how you calculate them in the script). Hence, try to create a sample qvw and share so that we can work on that to help you.

[senpradip007]

Go through this link http://community.qlik.com/message/322841#322841

[Anonymous]

Hi Tresesco,

Here is my data fields.... i am working on personal editor...please send expressions here...

MasterCalendar:

LOAD

TempDate AS OrderDate,

Week(TempDate) AS Week,

Year(TempDate) AS Year,

Year(TempDate) + If(Month(TempDate)>=$(vFiscalMonth), 1, 0) as fYear, 

Month(TempDate) AS Month,

Mod(Month(TempDate)-$(vFiscalMonth), 12)+1   as fMonth,

Day(TempDate) AS Day,

WeekDay(TempDate) AS WeekDay,

'Q' & Ceil((Mod(Month(TempDate)-$(vFiscalMonth), 12)+1)/3) AS Quarter,

Date(MonthStart(TempDate), 'MMM-YYYY') AS MonthYear,

Week(TempDate) & '-' & Year(TempDate) AS WeekYear,

InYearToDate(TempDate, $(vToday), 0) * -1 AS CurYTDFlag,

InYearToDate(TempDate, $(vToday), -1) * -1 AS LastYTDFlag

Resident TempCal Order By TempDate ASC;

DROP Table TempCal;