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

Need to group the data for 4 months

HI all,

Need to group the data for 4 months.

please see the image below. I have attached sample .qvf file

quarter.png

1 Reply
JonnyPoole
Former Employee
Former Employee

= MakeDate( year(CanonicalDate), 1+ (floor(Month(CanonicalDate)-1/4)*4),1)

And sort the date dimension in the chart by numeric ascending

Capture.PNG