topic Re: Previous year quarter in QlikView

Previous year quarter

Mon, 09 Jun 2014 07:14:21 GMT

Hello all,

I need to calculate count for previous year quarter where Year is in format =2014-2015 like current year is 2014-2015 and quarter Q1 ,i need to calculate count for year 2013-2014 quarter Q1??

Re: Previous year quarter

MK_QSL — Mon, 09 Jun 2014 07:17:14 GMT

From which month your quarter starts? question is because need to know whether you are using Financial Year or not !

Re: Previous year quarter

senpradip007 — Mon, 09 Jun 2014 07:21:28 GMT

In the Master Calendar you can create Calendar Year, Financial Year, Financial Month, Financial Quarter.

you can use this script:

Load
Dual([Calendar Year]-1 &'/'& [Calendar Year], [Calendar Year]) as FYear,
Dual([Calendar Month], fMonth) as FMonth,
Dual([Calendar Year]&'-'&'Q'&Ceil(fMonth/3), [Calendar Year]*100+Ceil(fMonth/3)) as FQuarter,
CalendarYear,
CalendarMonth

Resident Fact;

Re: Previous year quarter

Mon, 09 Jun 2014 07:24:26 GMT

April month ,ya i am using financial year

Re: Previous year quarter

lironbaram — Mon, 09 Jun 2014 07:25:43 GMT

i would suggest that for future calculation , you would create a numeric field for year

for example 2013-2014 will be 2013 , and 2014-2015 will be 2014

here are two examples

1. using numeric fields

sum({<Year={"$(=max(Year)-1)"}>} Sales)

2. using your field

sum({<Year={"$(=num(left(MaxString(YEAR),4))-1 & '-' & left(MaxString(YEAR),4))"}>} Sales)