topic Re: Month(today()) returning null value in QlikView

Month(today()) returning null value

Tue, 31 Dec 2013 13:13:58 GMT

Hi All,

It's NYE, so this is probably a result of the end of the working year, but this is confusing the life out of me.

I have two variables I'm declaring at the beginning of my script:

let vCurrentYear = year(today());

let vCurrentMonth = month(today());

The first correctly returns 2013.

The second appears to return a null value (to check I put both into separate text objects on my sheet. The vCurrentMonth displays as '-', the vCurrentYear as '2013').

Any ideas?

Thanks!

Rory.

Re: Month(today()) returning null value

Peter_Cammaert — Tue, 31 Dec 2013 13:22:58 GMT

Works for me though. Are you sure you made no spelling mistakes in your text box?

To be sure, open Settings->Variables in your QV Desktop and check the value of vCurrentMonth.

Peter

Re: Month(today()) returning null value

sivarajs — Tue, 31 Dec 2013 13:30:13 GMT

try by using

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; in script

Re: Month(today()) returning null value

Tue, 31 Dec 2013 13:33:24 GMT

OK - more confusion now!

In the Variable Overview it shows that vCurrentMonth has a value of 'Dec'. Isn't Month() supposed to return an int? On the text box I used the variable lookup dropdown to insert the variable name, so shouldn't be a spelling issue '=$(vCurrentMonth)' is the value in the text box expression.

Re: Month(today()) returning null value

Peter_Cammaert — Tue, 31 Dec 2013 13:39:25 GMT

Aha! I see...

Put the following in your text box expression window:

='$(vCurrentMonth)'

That should work.

Best wishes,

Peter

Re: Month(today()) returning null value

Tue, 31 Dec 2013 13:41:58 GMT

Rory Webber wrote:

Isn't Month() supposed to return an int?

Month() returns a dual data type, i.e. text and a number. You need to use Num(Month(today())) to return an int.

Re: Month(today()) returning null value

jonathandienst — Tue, 31 Dec 2013 13:42:33 GMT

Month() returns a dual, which displays as 'Dec' but has an underlying value of 12. Don't use $() explansion as it will attempt to calculate the expression 'Dec' which will return null. Just use =vCurrentMonth.

The $() expansion works for the year, because that is straight numeric, but it is unnecessary, so also use =vCurrentYear

HTH

Jonathan

Re: Month(today()) returning null value

Tue, 31 Dec 2013 13:43:25 GMT

=num(Month(Today()); then you have your int.

Re: Month(today()) returning null value

suniljain — Tue, 31 Dec 2013 13:48:58 GMT

Please try

=Text(Month(today()))

Re: Month(today()) returning null value

Tue, 31 Dec 2013 14:03:22 GMT

Hi ,

can u pls try this

=month(Now())

Re: Month(today()) returning null value

Tue, 31 Dec 2013 15:01:26 GMT

Always try and avoid the Now() function since it polls the operating system every second and hence could slow down the system. Use Today() instead.

Re: Month(today()) returning null value

Tue, 31 Dec 2013 15:19:42 GMT

Thank U