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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

Month on Month

Hello experts I need to get a bar chart that shows average Month on month Customer satisfaction ratings from the month of April 2018 to April 2019. That is, the average customer satisfaction rating for each month. Below is the code  I  but it does not give the expected results.  What I get is May 2018 to May 2019. Your help will be greatly appreciated.

Thanks.

Sum({<[Date]={">=$(=QuarterStart(Today(),-1)) <=$(=QuarterEnd(Today(),-1))"}>}[CusSat Rating])/

Count({<[Date]={">=$(=QuarterStart(Today(),-1)) <=$(=QuarterEnd(Today(),-1))"}>}[CusSat Rating])

4 Replies
Sue_Macaluso
Community Manager
Community Manager

@Pomna Are you using QlikView or Sense? I would like to move this into the correct product forum. 

Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!
Pomna
Creator III
Creator III
Author

yes

 

Sue_Macaluso
Community Manager
Community Manager

@Pomna I am sorry, is it Qlik View or is it Qlik Sense you are using. 

Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!
Pomna
Creator III
Creator III
Author

qlik sense