Time shifting by few hours

glatocha — Mon, 24 Mar 2025 04:55:44 GMT

Hi all,

all my data in my system database are stored in the UTC format. When I import it to Qlik I can use convert to local time function, but on top of this I need to shift the time by few hours as the customer expects the "daily" reports from 8am to 8am next day. Is there a function to shift it by hours?

Re: Time shifting by few hours

Vegar — Mon, 24 Mar 2025 06:01:18 GMT

You can use DayName() and its 3rd parameter to specify an offset to change when a day start.

Try something like this.

Dayname(YourDateValue, 0, 1/3) as YourAdjustedDateValue

topic Re: Time shifting by few hours in Connectivity & Data Prep

Time shifting by few hours

Re: Time shifting by few hours