topic Re: Combining Dates in QlikView

Combining Dates

Fri, 16 Oct 2015 10:57:03 GMT

Hi I have splitted the date fields as Year, Month, Day , Hour , Minutes, seconds while loading the data inorder to optimize the dashboard.

Now I need timestamp format of the date which is splitted while loading in the dashboard.

Please help

miguelbraga — Fri, 16 Oct 2015 11:02:32 GMT

Hi Hitha,

Use this expression:

=timestamp(makedate(YearField, MonthField, DayField) + maketime(HourField, MinuteField, SecondField)) as TimestampDate

Tell me if this is what you're looking for!

Fri, 16 Oct 2015 11:17:01 GMT

Hi,

if you use this in load

year(date) as year

month(date) as month

and so on,

why you dont keep the date with out split in addition to year and month etc.

Kushal_Chawda — Fri, 16 Oct 2015 11:24:44 GMT

try below expression in Dimension or Expression

=timestamp(timestamp#(Year&'-'&Month&'-'&Day&' '&Hour&':'&Minutes&':'&seconds,'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYY hh:mm:ss')