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