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)] .
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:
QuarterName(MakeDate(YEAR,MONTH)) as Quarter1,
'Q' & ceil(MONTH/3) as Quarter2;
SQL SELECT MONTH,YEAR FROM FACT;
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!
Retrieving data ...