QlikView App Dev

[#1]

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]

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!

[#3]

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]

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')