topic Re: Chart Title Formula in QlikView

Chart Title Formula

knightwriter — Mon, 30 Mar 2015 10:41:43 GMT

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.

Re: Chart Title Formula

MK_QSL — Mon, 30 Mar 2015 10:43:26 GMT

='Completed ' & Date(Today())

Re: Chart Title Formula

knightwriter — Mon, 30 Mar 2015 10:46:03 GMT

Hi Manish,

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

Re: Chart Title Formula

ashfaq_haseeb — Mon, 30 Mar 2015 10:46:53 GMT

HI,

Just write below in window's Title.

='Compleated '&today()

Regards

ASHFAQ

Re: Chart Title Formula

jsanchezh — Mon, 30 Mar 2015 10:47:42 GMT

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

='Completed ' & date(today())

Re: Chart Title Formula

sagarkharpude — Mon, 30 Mar 2015 10:47:42 GMT

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

Re: Chart Title Formula

ashfaq_haseeb — Mon, 30 Mar 2015 10:48:13 GMT

Like this

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

Regards

ASHFAQ

Re: Chart Title Formula

avinashelite — Mon, 30 Mar 2015 10:49:26 GMT

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())

Re: Chart Title Formula

Mon, 30 Mar 2015 10:51:15 GMT

try like this expression

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

Re: Chart Title Formula

MK_QSL — Mon, 30 Mar 2015 10:53:34 GMT

'Completed ' & Month(Today())