topic Re: Difference between Timestamp and Timestamp# in QlikView

Difference between Timestamp and Timestamp#

pgarcia75 — Fri, 27 May 2011 07:03:13 GMT

Hello

I'm new with QlickView, and I trie to load a field from CSV file. The field is under the format 'DD/MM/YYYY mm:hh'

What the difference with timestamp(XX) and timestamp#(XX) in the script to load file ?

The result is different, when I trie to compar date loaded with date of the day

Thank for the response

Difference between Timestamp and Timestamp#

brenner_martina — Fri, 27 May 2011 07:21:56 GMT

Hi,

Timestamp#() means, that QV interpret the format from the source like you need, p.e.

Timestamp#('20110512 08:22','YYYYMMDD hh:mm') As Timestamp or

Timestamp#('05-12-2011 08.22:32','MM-DD-YYYY hh.mm.ss') As Timestamp

And Timestamp() means the default format you wish to be shown in your application

Timestamp('12-05-2011 08:22','DD.MM.YYYY hh:mm') As Timestamp

often you need to combine both functions

Timestamp(Timestamp#('20110512 08:22','YYYYMMDD hh:mm'),'DD.MM.YYYY hh:mm') As Timestamp

Re: Difference between Timestamp and Timestamp#

pgarcia75 — Fri, 27 May 2011 12:09:18 GMT

Thanks for the response

In complement, if in my script, I have

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
...
LOAD
..
Timestamp#([Heure d'ouverture]) as [Open_Incident],

In a Chart Objet, the expression : count({1<Open_Incident={">=$(=MonthStart(AddMonths(now(2),-3)))"}>}[ID Incident]) return datas

When I have
Timestamp#([Heure d'ouverture],'DD/MM/YYYY hh:mm') as [Open_Incident],

In a Chart Objet, the expression : count({1<Open_Incident={">=$(=MonthStart(AddMonths(now(2),-3)))"}>}[ID Incident]) return non data

Can you explain why ?
Thanks
P