Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Deriving the Quarters

Hi All,

I have a Calendar i.e July-June and i need to derive Quarters like this:

July-Sep = Q1

Oct-Dec= Q2

Jan-Mar=Q3

Apr-June=Q4

I Have a column for Month, by using this how to derive Quarters?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

'Q' & ceil(match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')/3)


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

'Q' & ceil(match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')/3)


talk is cheap, supply exceeds demand
sujeetsingh
Master III
Master III

If you have the Date field then just use month start() or just nested iff as

If(wildmatch('July','Aug','Sept',Month),'Q1'--

sujeetsingh
Master III
Master III

This can also work

'Q' & ceil(month/3)