topic Current and Previous Quarter in QlikView

Current and Previous Quarter

alec1982 — Mon, 25 Nov 2013 20:06:09 GMT

Hi,

I have atable that has Quarter as follow:

Quarter

2011/1

2011/2

2011/3

...

2013/4

2014/1

...

I need to define the Current and the previous Quarter based on today's date..

Anybody has a solution?

Thxs

Re: Current and Previous Quarter

mphekin12 — Mon, 25 Nov 2013 21:06:34 GMT

You can try using Autonumber(). Here is an article that might point you in the right direction:

Set Analysis: Nested If Statement into Set Analysis

Re: Current and Previous Quarter

Josh_Good — Mon, 25 Nov 2013 22:00:20 GMT

Try this expression:

Today's Quarter:

=Year(Today()) & '/' & Ceil(Month(Today())/12*4)

Last Quarter:

=Year(AddMonths(Today(),-3)) & '/' & Ceil(Month(addMonths(Today(),-3))/12*4)

Re: Current and Previous Quarter

Tue, 26 Nov 2013 05:47:54 GMT

Hi,

If you want Quarter Date then use:

QuarterStart (Today()) //For Quarter Date

QuarterName: QuarterName(Today()) //For Quarter Name

For Previous Quarter:

QuarterStart (Today(), -1) // For Quarter Date

QuarterName: QuarterName(Today(), -1) //For Quarter Name

If your requirement not fullfill then please attach any sample file for more clarification.

Regards,

Ashutosh

Re: Current and Previous Quarter

VishalWaghole — Tue, 26 Nov 2013 06:01:18 GMT

Hi,

PFA attachment....

Thanks and Regards,

Vishal Waghole

Re: Current and Previous Quarter

Tue, 26 Nov 2013 06:11:36 GMT

Hi, Try This hope it will help

Dimension: Quarter

Expression:

=Sum({<CommonDateField={">=$(=Date(QuarterStart(vMaxDate, -1)))<=$(=Date(floor(QuarterEnd(vMaxDate))))"}>}Sales)

Variable:

vMaxDate: =Date(max(CommonDateField),'DD/MM/YYYY')

Re: Current and Previous Quarter

Tue, 26 Nov 2013 06:38:58 GMT

Hi,

Try below:

Current Year and Quarter = Year(QuarterStart(Today())) & '/' & Ceil(Month(QuarterStart(Today()))/3)

Previous Year and Quarter= Year(QuarterStart(Today(),-1)) & '/' & Ceil(Month(QuarterStart(Today(),-1))/3)