topic Re: Straight Table - Window Title Expression in QlikView

Straight Table - Window Title Expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i am using this expression in Window Title: = 'Projects Completed in ' & month(month(vtoday)-1) and the value i am getting is below:

Projects Completed in 8

vToday variable is giving todays date

expectation of the result is:

Projects Completed in August

please advise

thanks in advance

Sukhwant

Re: Straight Table - Window Title Expression

arulsettu — Fri, 16 Sep 2016 09:12:35 GMT

try this

month(Today())-1

Re: Straight Table - Window Title Expression

tresB — Fri, 16 Sep 2016 09:13:36 GMT

Try like:

'Projects Completed in ' & month(Addmonths(vtoday,-1))

Re: Straight Table - Window Title Expression

Anonymous — Fri, 16 Sep 2016 09:14:12 GMT

try this Expression:

'Projects Completed in ' & date($(vtoday),'MMMM')

Re: Straight Table - Window Title Expression

jonathandienst — Fri, 16 Sep 2016 09:14:53 GMT

Like this:

= 'Projects Completed in ' & Month(vtoday-1)

(assuming vtoday is a valid QV numeric date)

Re: Straight Table - Window Title Expression

Fri, 16 Sep 2016 09:39:19 GMT

did not work

Re: Straight Table - Window Title Expression

Fri, 16 Sep 2016 09:40:01 GMT

did not work

Re: Straight Table - Window Title Expression

Fri, 16 Sep 2016 09:41:24 GMT

as today September is coming, i need value as August, so your suggestions will not work

Re: Straight Table - Window Title Expression

Fri, 16 Sep 2016 09:41:35 GMT

as today September is coming, i need value as August, so your suggestions will not work

Re: Straight Table - Window Title Expression

jonathandienst — Fri, 16 Sep 2016 09:44:20 GMT

= 'Projects Completed in ' & Month(AddMonths(Today(), -1))

If vtoday is a valid QV numeric date (and remember that variable names are case sensitive - vtoday and vToday are two distinct variables):

= 'Projects Completed in ' & Month(AddMonths(vtoday, -1))

= 'Projects Completed in ' & Month(AddMonths(vToday, -1))

Re: Straight Table - Window Title Expression

Anonymous — Fri, 16 Sep 2016 09:44:44 GMT

try

'Projects Completed in ' & date(addmpnths(vtoday,-1),'MMMM')

your variable is correct vtoday or vToday?

in your first mail you mentioned vToday has todays date

Re: Straight Table - Window Title Expression

chetansehgal — Fri, 16 Sep 2016 09:46:53 GMT

Try this:

='Text' & left(MonthName(addmonths(Today(),-1)),3)

Re: Straight Table - Window Title Expression

tresB — Fri, 16 Sep 2016 09:47:06 GMT

Try:

month(Addmonths(today(),-1))

Re: Straight Table - Window Title Expression

Anonymous — Fri, 16 Sep 2016 09:48:36 GMT

Hi,

use this expression.

='Projects Completed in ' & month(Addmonths(Today(),-1))

regards,

Venkata Sreekanth