Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Split the Year in Quartiles

I have loads of dates and I need to split each year into quartiles.

How would I do that? As after I will have to display a set of data for each quartile.

3 Replies
vivientexier
Partner - Creator II
Partner - Creator II

Ceil(Month(Date)/3) as Quarter

Not applicable
Author

How would I use this?

I need to have 4 quartiles, e.g. dec, jan, feb for each year. Then I have to create a table to display the highest values for each quartile.

vivientexier
Partner - Creator II
Partner - Creator II

In your script.

You have a date.


Let's create a new field with your date field.

Ceil(Month(Date)/3) as Quarter

This formula will give you 1 for January, 1 for February, 1 for march and 2 for April.