topic AW:Re: AW:Previous year quater data display in QlikView

Previous year quater data display

Fri, 29 Apr 2011 11:00:35 GMT

Dear all,

I want to do the calculation of sales data by quarter to data means quarter to date of this year and quarter to date of prev year.

I am getting quarter to date of this year data but dont know how to display quarter to dat of previous year.

Please help its urgent.

Regards,

Pranav

AW:Previous year quater data display

brenner_martina — Fri, 29 Apr 2011 11:08:12 GMT

Hi, Pranav,

you can use the function InQuarterToDate.

AW:Previous year quater data display

Fri, 29 Apr 2011 11:36:27 GMT

Dear Martina,

through InQuarterToDate() only i am calculation QTD and PQTD but my PQTD it is CVomming as this year p[revious quarter but i want previous year same Quarter.

Ex: If my QTD is QTR2 of 2011 then my PQTD should be QTR2 of 2010.

My calculation with InQuarterToDate() is :

IF(InQuarterToDate(PeriodDate,today(),0),1,0) as QTD_VoyStart,
IF(InQuarterToDate(PeriodDate,today(),-1),1,0) as PQTD_VoyStart,

but the PQTD_VoyStart givse this year previous Qtr.

Please Suggest a answer .

Thanks

regards,

Pranav

AW:Re: AW:Previous year quater data display

brenner_martina — Fri, 29 Apr 2011 12:13:46 GMT

Dear Pranav,

does set analysis work like this, if you calculate in calendar quarter like:

Num(Ceil(Month(Datefield)/3)) as Quarter

Sum({<Year={$(=Only(Year-1))},Quarter={$(=Quarter)}>} Field)

AW:Re: AW:Previous year quater data display

Sat, 30 Apr 2011 07:22:08 GMT

Dear Martina,

May be the Setanalysis will work i have not Checked it,

I have done the above code in Calender in Script and it works fine.

Will try for setanalysis also and let u know.

Thanks

regards,

Pranav