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: 
Not applicable

Reg:Query on Quarter

Hi All,

I want to start my quarters with Apr-Mar.Wat is the simplest way to create Quarters.Please let me know.

Thanks&Regards

Jai

1 Reply
Anonymous
Not applicable
Author

The simpliest way to create Quarters is

(Div(Month([Date])-1,3)+1) as Quarter

With this you can manipulate to have Apr-Mar quarter as first

Rgds,
Artjoms