Create Q1 - 2013 and Q1 - JAN from Date field

[hkg_qlik]

Hi all,

I have a date field in my Fact table. Now using the DATE I need to create Quarter - Year and Quarter - Month.

Can someone help me with the script?

Thanks,

H

[Anonymous · Accepted solution]

Quarter Year:

='Q' & ceil(month(Date)/3) & ' - ' & year(Date)

Quarter Month:

='Q' & ceil(month(Date)/3) & ' - ' & date(Date, 'MMM')

[jonasheisterkam]

='Q'&ceil(Month('11.3.2014')/3)&'-'&year('11.3.2014') ='Q'&ceil(Month('11.3.2014')/3)&'-'&month('11.3.2014')

[Anonymous]

Hi

Looks like you may well need to be introduced to the concept of a Master Calendar.

Search this QlikCommunity for Master Calendar and you'll get plenty of hits.

Best Regards,     Bill