You missed a ' in your expression - or is that just mistyping when you wrote the question?
If not - then make sure that completiondate is actually a real date for QlikView by looking at what Num(completiondate) looks like. That will give you a number in 40000's with possibly some fraction.... then it is a real date to QlikView...
SET TimeFormat='h:mm:ss TT';
i believe its a string - so how would i convert it to a date and then a month year?
Just to be sure I help you with the right problem .... Where do get the dash - as the result from this expression:
Is it in a Text Box, a Chart or where?
If you use the expression without being wrapped in an aggregate function as expression in a chart you will get a
dash if not a single value is picked out with the dimensions in the chart... Could that be the case?
I have in my qvw file this settings which are ok
But when I import dato from excel i get something like 41306.000000
If i only got the 41360 then qlikview would see it as a date, but it does not because of the .000000
Excel format is date but it sends it with extra ceros.
What can I do to cut the . and the ceros
Thanks in advance
I had similar problem with importing data. I tried importing from xlsx and from csv with ; delimiter but the problem persists. I see dates with no selection applied but they disappear when I apply filter by Date because they don't treated as dates.
My data is in csv file on linux samba server. I used
$cut -f -4 --delimiter=' ' filename.csv > filename-1.csv
to cut the time portion from datetime field (it is the fifth last in lines of my csv file) and then importing in QlikView with
load date(OrderDate,'YYYY-MM-DD') as OrderDate
from ......csv file
This solve my problem.