topic how to create quarter in mysql database in QlikView

how to create quarter in mysql database

Wed, 26 Sep 2012 16:17:21 GMT

DEAR TEAM,

I HAVE A TABLE AS

SELECT MONTH,YEAR FROM FACT; in mysql database

But plz tell me the command by which i can devide the MONTH or Year Columns in 4 Quarter[Q1(jan-march),Q2(april-jun),Q3(july-sep),Q4(oct-dec)] .

Regards,

Rahul

Re: how to create quarter in mysql database

hic — Thu, 27 Sep 2012 07:42:48 GMT

You can define a Quarter in the QlikView script using a preceding Load. (I assume that YEAR and MONTH are numeric.) Below you have two alternatives:

Load *,

QuarterName(MakeDate(YEAR,MONTH)) as Quarter1,

'Q' & ceil(MONTH/3) as Quarter2;

SQL SELECT MONTH,YEAR FROM FACT;

HIC

Re: how to create quarter in mysql database

Thu, 18 Oct 2012 15:25:37 GMT

You can use the below command to get a resulting Q1 through Q4 for your months. All you would need to do is replace TempDate with your date field. You just need to add this line into your load script where the date field is being loaded.

'Q' & ceil(month(TempDate) /3) as Quarter

Hope this helps!