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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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