topic Re: shift differential calculation in QlikView

shift differential calculation

Mon, 26 Jan 2026 16:26:21 GMT

Hello,

I have big troubles with calculation some values, because our company wants that i calculate data by date, BUT where the day begins with 6am and ends with 6am on the next morning.

How can i calculate this differential when i have seperate data for year, month, day, hour, minute?

Thanks, Armin

Re: shift differential calculation

MarcoWedel — Tue, 20 Jan 2015 17:12:07 GMT

subtract 6 hours from your timestamps and load the result as a new field.

Re: shift differential calculation

MarcoWedel — Tue, 20 Jan 2015 17:20:52 GMT

something like:

LOAD *,

Week(Date) as Week,

Month(Date) as Month,

Year(Date) as Year;

LOAD timestampfield,

DayName(timestampfield-'06:00:00')) as Date,

someotherfields

FROM yoursource;

Re: shift differential calculation

MarcoWedel — Tue, 20 Jan 2015 17:24:54 GMT

or as you already have seperate fields for year, month, day, hour, minute:

LOAD *,
          Week(Date) as Week,
          Month(Date) as Month,
          Year(Date) as Year;
LOAD *,
          DayName(timestampfield-'06:00:00')) as Date;
LOAD Timestamp(Makedate(year, month, day)+Maketime(hour, minute)) as timestampfield,
        someotherfields
FROM yoursource;

hope this helps

regards

Marco