topic Re: How to get Previous Quarter in QlikView

How to get Previous Quarter

Mon, 25 May 2015 11:13:01 GMT

hi everyone,

I m able to get the Previous year Value ...sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount..

on the same basis i want to get Previous Quarter Value as well..LIke when i select Q4,, I can see value of Q4 and Q3..

Re: How to get Previous Quarter

Mon, 25 May 2015 11:21:12 GMT

Hi,

VPrevQuarter=peek('Quarter');

VPrevQuarter=previous(getfieldselections(Quarter))

sum({$<Quarter = {'$(VPrevQuarter)'}>}Price_Pcs_Incl_Discount..

Re: How to get Previous Quarter

maxgro — Mon, 25 May 2015 11:22:39 GMT

add a new field to your calendar (if any), then use set analysis on the new field (as you did for year, quarter is max(new field)-1)

new field

2010Q1 1

2010Q2 2

.....

2011Q1 5

....

2015Q4 20

2015Q1 21

Re: How to get Previous Quarter

Mon, 25 May 2015 11:34:08 GMT

hi shravan,

its not working .. i m not getting and Value.. i m Able to do a for Current Quater..

.sum({$<Quarter= {$(=max(Quarter))}>}Price_Pcs_Incl_Discount..

But i want for last Quarter// Like if i select Quarter3 and i get value of Quarter2

Re: How to get Previous Quarter

Mon, 25 May 2015 13:20:42 GMT

Hi Maurya,

Create a Date field and then try like this

sum({$<Date = {">=Quarterstart(Date,-1)<=Quarterstart(Date)"}>}Price_Pcs_Incl_Discount...

Thanks

Harsha Nandan

Re: How to get Previous Quarter

Tue, 26 May 2015 06:08:22 GMT

its not giving a Proper Value..can u send me any other way to do this

Re: How to get Previous Quarter

tresB — Tue, 26 May 2015 06:22:06 GMT

It majorly depends on metadata format. Try to create your sample qvw and share.

Re: How to get Previous Quarter

Wed, 27 May 2015 12:42:00 GMT

Are you directly getting the Quarter field or otherwise calculated from the date field?

Re: How to get Previous Quarter

Thu, 28 May 2015 05:16:06 GMT

i m Calulating...

QuartersMap:

MAPPING LOAD

rowno() as Month,

'Q' & Ceil (rowno()/3) as Quarter

AUTOGENERATE (12);

what i want .. if i clik year say 2015 and select Q4.. it show sum of sales for Q4 and Q3.. as well when i click Q1 it shows Q4 of 2014..

Re: How to get Previous Quarter

Thu, 28 May 2015 10:39:21 GMT

If you create like this..I think it will forms a data island ...because of this it is not showing data exactly...

Re: How to get Previous Quarter

maxgro — Thu, 28 May 2015 11:50:19 GMT

PFA

Re: How to get Previous Quarter

Thu, 28 May 2015 12:27:34 GMT

Thanks Massimo...Its Working Fine..

Re: How to get Previous Quarter

maxgro — Thu, 28 May 2015 12:58:04 GMT

please, if you get the answer, close the thread

thanks