Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Is it possible to create quarter on Month object

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

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: Is it possible to create quarter on Month object

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

Months:

LOAD

  *,

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

LOAD * INLINE [

TESTMONTH

1

2

3

4

5

6

7

8

9

10

11

12

];

View solution in original post

3 Replies
Highlighted
Specialist II
Specialist II

Re: Is it possible to create quarter on Month object

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...

Highlighted
Not applicable

Re: Is it possible to create quarter on Month object

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

Highlighted
Specialist
Specialist

Re: Is it possible to create quarter on Month object

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

Months:

LOAD

  *,

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

LOAD * INLINE [

TESTMONTH

1

2

3

4

5

6

7

8

9

10

11

12

];

View solution in original post