Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],
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],
thank you
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