Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help required in dynamic chart title!

Hi All,

This is the expression i use for displaying the chart title. What i want i instead of displaying the in numbers i want to show the month name in words. So i am not sure what changes has to be done with Max(Month) in my script to get the required result.

===Max(Month) & ',' &Max(Year) &' vs ' & (Max(Month)-1) & ',' &Max(Year)& ' Sales Growth @ ' & num(Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month))}>} SalValue) / Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month)-1)}>} SalValue), '#%')


By the way i have INLINE in my script to show the month name in words. It has been given below. Check whether anything can be done with this in the above expression.

MonthName:
load * inline [
Month, MonthName
4,Apr
5,May
6,Jun
7,Jul
8,Aug
9,Sep
10,Oct
11,Nov
12,Dec
1,Jan
2,Feb
3,Mar];


Thanks and Regards,

Rikab

10 Replies
Not applicable
Author

Hi Martin!

Thanks a ton! Exactly the one i was looking for. It works perfectly!

Regards,

Rikab