topic Re: quarters for the year in QlikView

quarters for the year

Mon, 25 Apr 2016 14:46:02 GMT

I would like to break quarters into the quarters for a certain year. For example: Q1 2015, Q2 2015, Q3 2015

How is that done?

ShareRates:

LOAD
year([Month_datefield/ShareRates])as calendaryearonly,
*;

LOAD

if(match(date(datefield, 'MMM'),'Jan','Feb','Mar') > 0, 'Q1',
if(match(date(datefield,'MMM'),'Apr','May','Jun') > 0, 'Q2',
if(match(date(datefield,'MMM'),'Jul','Aug','Sep') > 0, 'Q3',
if(match(date(datefield, 'MMM'),'Oct','Nov','Dec') > 0, 'Q4')))) as Sharedratesquarter_group,
date(datefield,'MMM-YYYY')as [Month_datefield/ShareRates],

Re: quarters for the year

sunny_talwar — Mon, 25 Apr 2016 14:49:23 GMT

May be this:

LOAD
year([Month_datefield/ShareRates])as calendaryearonly,
*;
LOAD
'Q' & Ceil(Month(datefield)/3) as Sharedratesquarter_group,
date(datefield,'MMM-YYYY')as [Month_datefield/ShareRates],

Re: quarters for the year

Mon, 25 Apr 2016 18:31:57 GMT

thank you

Re: quarters for the year

sunny_talwar — Mon, 25 Apr 2016 18:36:28 GMT

Did it work? If it did, would you mind closing the thread down by marking the correct answer above? If not, would you be able to elaborate what is the issue still?

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny