Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

dynamic chart title

I need help setting up dynamic chart title. I need the title to show customer satisfaction rating for last month like below

May: 4.5

June: 4.75

Below is my code

To get the month 
NUM('date(AddMonths(Today(), -2),'MMM')  

To get customer satisfaction rating
Sum({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating])
/
Count ({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating]),'##.00'))

I need to combine both codes to get  May: 4.5

3 Replies
jwjackso
Specialist III
Specialist III

Try:

=date(AddMonths(Today(), -2),'MMM')&':'& 

NUM(Sum({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating])
/
Count ({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating]),'##.00'))

Pomna
Creator III
Creator III
Author

Thanks for your reply but it does not solve my issue. I still get an error

Pomna
Creator III
Creator III
Author

Thank you Jwjackso,

I removed the column and I of the closing brackets and it worked. Below is the code

 

=date(AddMonths(Today(), -1),'MMM')&' '&
NUM(Sum({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating])
/
Count ({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating]),'##.00')

Thank you