Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],
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.
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.
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#())
Have the same issue,
whats the solution?
"I think, the problem is, that your system date format does not correspond to the date format which has been used in QlikView."
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.
/e
Simply, show the date field in the QV application. Then you should see the full date string as read from database
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
/e