Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combining Dates

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

3 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

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!

Not applicable
Author

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