topic From tutorial, Year/Month coming up empty in QlikView

From tutorial, Year/Month coming up empty

Mon, 16 Nov 2009 18:44:29 GMT

Hi all. Trying to get through the getting started tutorials, but am having some problems. I am following the steps exactly as they are provided. However, in the tutorial video the added rows (Year & Month) are filled with years and months when "Select field...". My fields "Year" & "Month" are however empty.

The [Invoice Date] does contain alot of dates, so probably shouldn't have anything to do with that (?).

I'm completely new with QV, so please bare with me [:)]

Thanks!

Code:

[Invoice Date],
Year ([Invoice Date]) as Year,
Month ([Invoice Date]) as Month,
[Invoice Number],

From tutorial, Year/Month coming up empty

Mon, 16 Nov 2009 19:02:16 GMT

I think, the problem is, that your system date format does not correspond to the date format which has been used in QlikView.

Maybe you try something like

date(date#([Invoice Date],<Dateformat>))

instead of [Invoice Date].

You must enter something like 'YYYY-MM-DD' for <Dateformat> depending on the output you see for Invoice Date.

example:

date(date#([Invoice Date],'YYYY-MM-DD'))

Hope this helps.

From tutorial, Year/Month coming up empty

Mon, 16 Nov 2009 19:07:30 GMT

and maybe

date#([Invoice Date],<Dateformat>)

is enough...

I don't know really. You have to try and play a little bit with the date function (date()) and date conversion function (date#())

From tutorial, Year/Month coming up empty

Thu, 11 Mar 2010 17:17:08 GMT

Have the same issue,

whats the solution?

From tutorial, Year/Month coming up empty

Fri, 12 Mar 2010 08:59:47 GMT

"I think, the problem is, that your system date format does not correspond to the date format which has been used in QlikView."

From tutorial, Year/Month coming up empty

Fri, 12 Mar 2010 09:18:03 GMT

Is it possible to se my system date format ?
Can i Change it or can I write the code differently?

no of the above examples works.

From tutorial, Year/Month coming up empty

Fri, 12 Mar 2010 09:22:01 GMT

Simply, show the date field in the QV application. Then you should see the full date string as read from database

From tutorial, Year/Month coming up empty

Fri, 12 Mar 2010 10:18:44 GMT

I have

SET DateFormat='YYYY-MM-DD';

Invoice Date looks like this

13/12/2007

But I cant change the dateFormat variable (still no data).

Year ([Invoice Date]) as Year