topic Re: Is it possible to create quarter on Month object in QlikView

Is it possible to create quarter on Month object

Fri, 08 Aug 2014 10:36:04 GMT

Hello Everyone,

Any body please tell me is it possible to create Quarter object based on the month, i do not have date object with me

Thanks in advance

agomes1971 — Fri, 08 Aug 2014 10:40:44 GMT

if(month<=3,'Quarter1',if(month>3 and month<=6;'Quarter 2';if(month>6 and month<10;'Quarter 3','Quarter 4')))

something like this...

Fri, 08 Aug 2014 10:44:25 GMT

You can hard code this by this

If(match(Month,'Jan','Feb','Mar'),'Q1',If(match(Month,'Apr','May','Jun'),'Q2',if(match(Month,'Jul','Aug','Sep'),'Q3','Q4')))

hope above code will help you

regards

bhawna

DavidFoster1 — Fri, 08 Aug 2014 10:54:19 GMT

If you have the month number then a simple function will work nicely.

Months:

LOAD

'Q' & CEIL(TESTMONTH/3) AS TESTQTR;

LOAD * INLINE [

TESTMONTH

];