topic Quarters in QlikView

Quarters

kevbrown — Fri, 12 Sep 2014 07:59:34 GMT

To change a date to month i can use the function

date(monthstart(ukmpsmr_risk.INCEPTION_DATE),'MMM-YY')

But how to I change a date to a Quarter? I've got

date(QuarterName(ukmpsmr_risk.INCEPTION_DATE),'MMM-YY')

But that returns the quarter start month so Jan-14, I want Qtr 1

rubenmarin — Fri, 12 Sep 2014 08:08:09 GMT

you can use:

='Qtr ' & Ceil(Month(ukmpsmr_risk.INCEPTION_DATE)/4)

tresB — Fri, 12 Sep 2014 08:08:12 GMT

rubenmarin — Fri, 12 Sep 2014 08:10:20 GMT

My bad english, if quarter is a 3-month period then it will be:

='Qtr ' & Ceil(Month(ukmpsmr_risk.INCEPTION_DATE)/3)

kevbrown — Fri, 12 Sep 2014 08:12:24 GMT

superb, thanks.