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: 
knightwriter
Creator III
Creator III

Chart Title Formula

Hi all,

Easy one for a Monday. I wanted to have the words "Completed" and todays date in title window, how can I do this?

Many thanks.

completed.PNG

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

='Completed ' & Date(Today())

View solution in original post

9 Replies
MK_QSL
MVP
MVP

='Completed ' & Date(Today())

knightwriter
Creator III
Creator III
Author

Hi Manish,

Thanks for the reply and the answer gives me the 30.03.15, how to I show this as "March"?

ashfaq_haseeb
Champion III
Champion III

HI,

Just write below in window's Title.

='Compleated '&today()

Regards

ASHFAQ

jsanchezh
Partner - Creator
Partner - Creator

You are not using the correct parameters for the inMonth funtion. But I think this should work:

      ='Completed ' & date(today())

sagarkharpude
Creator III
Creator III

='Completed ' & Date(Today(),'DD/MMM/YYYY')

ashfaq_haseeb
Champion III
Champion III

Like this

='Completed ' & Date(Today(),'DD/MMMM/YYYY')

Regards

ASHFAQ

avinashelite

Hi,

I don't know why your using INMONTH here , if you want to use inmonth function then in should has 3 parameter

EG:

InMonth (date, basedate , shift)

returns true if date lies inside the month containing basedate. The month can be offset by shift. Shift is an integer, where the value 0 indicates the month which contains basedate. Negative values in shift indicate preceding months and positive values indicate succeeding months.

Examples:

inmonth ( '2006-01-25', '2006-01-01', 0 ) returns true

inmonth ( '2006-01-25', '2006-04-01', 0 ) returns false

inmonth ( '2006-01-25', '2006-01-01', -1 ) returns false

inmonth ( '2005-12-25', '2006-01-01', -1 ) returns true

if you want only current date then use ='Completed ' & Date(Today())

Not applicable

hi

try like this expression

='Completed ' & Date(Today(),'DD/MMM/YYYY')

MK_QSL
MVP
MVP

'Completed ' & Month(Today())