New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Contributor II

Custom Calendar Period to Trimester -3 month interval

I have date field ProgramStartDate. Autocalendar provides me Quarter interval by default. I am looking to group programs by Timester. i.e. Programs in Jan to apr, May to Aug & Sep to Dec

Any thoughts?

Contributor II

I think you're talking about the quadrimester. Trimester is the same as quarter (total year divided in 4).

So, the total year divided in 3.

You can do this by:

ceil(month(ProgramStartDate)/4)

Consider the division as: The months are grouped by 4... which results in 3 pieces per year.

E.g.: '01/03/2018' is the thirth month, 3/4 = 0,75, ceil rounds up to 1.

'20/09/2018' = 9/4 = 2,25, ceil rounds up to 3

Anyway, you can apply the same technique for different groupings:

Trimester: ceil(month(ProgramStartDate)/3)

2-month interval: ceil(month(ProgramStartDate)/2)

Half year interval: ceil(month(ProgramStartDate)/6)

etc.