Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
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
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


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.


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