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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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
Former Employee
Former Employee

@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
Former Employee
Former Employee

@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