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: 
saradhi_it
Creator II
Creator II

Dynamic name changing of month names

Hi

i have a chart like below i need output of labels like this
if someone selects month and year from box it has to change the name of columns dynamically

(present selected month (nov 2013), Next month (Dec2013) , Next 3 months (Jan 2014-Mar 2014) )

Dynamic labels plz advice

Thanks
PS

dynamic.jpg

3 Replies
Anonymous
Not applicable

Expression for selected month: sum(Sales)

Expression for next month: sum({<yourdatefield={'=$(=addmonths(yourdatefield,1))'}>}Sales)

Expression for next 3 months: sum({<yourdatefield={'>=$(=addmonths(yourdatefield,2))<=$(=addmonths(yourdatefield,5))'}>}Sales)

donot know what you want as Total Sales? sum({<yourdatefield=>}Sales) ignoring date selection

maxgro
MVP
MVP

if y and m are the year and month field

=date(addmonths(makedate(max(y), max(m)),0), 'MMMYY')

=date(addmonths(makedate(max(y), max(m)),1), 'MMMYY')

=date(addmonths(makedate(max(y), max(m)),2), 'MMMYY') & '-' & date(addmonths(makedate(max(y), max(m)),4), 'MMMYY')

1.png

kavita25
Partner - Specialist
Partner - Specialist

If you have a date field, you can try below logic:

Nov-13

=date(MonthStart(AddMonths(Max(Date_field),0)),'MMM-YY')

Dec-13

=date(MonthStart(AddMonths(Max(Date_field),1)),'MMM-YY')

Jan14-Mar14

=date(MonthStart(AddMonths(Max(Date_field),2)),'MMMYY')

&'-'& date(MonthStart(AddMonths(Max(Date_field),4)),'MMMYY')

Regards,

Kavita