topic Timestamp not working in QlikView

Timestamp not working

senior_freshmen — Thu, 08 Jul 2021 13:01:06 GMT

hello Guys,

I know this Topic was already posted alot, but none of the suggestions seem to resolve my Problem.

I am uploading a CSV to an QS App and I would like to generate a MasterCalendar based on the transported Timestamp. (I'm really sure the "Timestamp" Field is in fact text by the csv file)

But the convert to a real Timestamp does not happen, If I want to use one of the converted Fields and make them e.g. to display only Month, it won't work.

Heres the script:

And now when I try to process my fields this is the output:

Thank y'all for your help and with best regards

Re: Timestamp not working

mikaelsc — Thu, 08 Jul 2021 13:23:04 GMT

timestamp(timestamp#(Created,'DD.MM.YYYY hh:mm')) ?

and your master calendar won't work, as you are trying to link a timestamp with a date.

if you don't care about the hours in your master calendar, create a date field in your facts table : date(floor(timestamp#(Created,'DD.MM.YYYY hh:mm'))) as Date, and generate a master calendar with "Date"

Re: Timestamp not working

MayilVahanan — Fri, 09 Jul 2021 04:22:12 GMT

Hi @senior_freshmen

Try like below

Timestamp(Timestamp#(Created,'DD.MM.YYYY HH:mm'),'DD.MM.YYYY HH:mm') as TimeStamp2

or, can you please attach the excel sheet.