topic Re: Quarter Start in QlikView

Quarter Start

kevbrown — Wed, 08 Oct 2014 09:46:29 GMT

I have the following dimension in a line garph - Ceil(Month(ukmpsmr_risk.INCEPTION_DATE)/3) - my problem is for some of my customers they're year starts in March so i need the quarters to start from March, the current expression will always start at January, any ideas?

Kev

Re: Quarter Start

sivarajs — Wed, 08 Oct 2014 09:52:55 GMT

Add 3 months to the date using addmonths will help

Ceil(Month(Addmonths(ukmpsmr_risk.INCEPTION_DATE,3))/3)

Re: Quarter Start

kevbrown — Wed, 08 Oct 2014 09:57:17 GMT

If i then select April it still says quarter 2, April should be part of quarter 1

Re: Quarter Start

Anonymous — Wed, 08 Oct 2014 09:59:04 GMT

Then try with

Ceil(Month(Addmonths(ukmpsmr_risk.INCEPTION_DATE,-3))/3)

April, May and June will appear in Quarter 1

July, August and September will appear in Quarter 2,

and so on..

Take into account last quarter will appear now in Quarter 1. I am not sure hat is what you need...

Marc.

Re: Quarter Start

kevbrown — Wed, 08 Oct 2014 10:03:11 GMT

Tried that, the quarters work for the labels but the sum expression doesn't. If i just select March, April and May the total is correct, if I select April to September Quarter 1 is inflated

Re: Quarter Start

aveeeeeee7en — Wed, 08 Oct 2014 10:03:23 GMT

Use this:

Ceil(Num(Month(Addmonths(ukmpsmr_risk.INCEPTION_DATE,-2)))/3) // It will start your month from March

You can also create Quarters in the Script:

'Q'&um(Month(Addmonths(ukmpsmr_risk.INCEPTION_DATE,-2)))/3) // It will start your month from March

Regards

Av7eN

Re: Quarter Start

kevbrown — Wed, 08 Oct 2014 10:07:54 GMT

worked a treat, thanks