topic Re: Time intervals in front end in QlikView

Time intervals in front end

MindaugasBacius — Thu, 04 Aug 2016 11:51:57 GMT

Hei.

I need some help because I am struggling with this issue for a while.

I do have a data table like:

The expression is like this:

I would like to group by the results according to City. The result should be divided into hours.

My result that I wish to accomplish is like this:

If that's possible would like to get the output in front end.

Could anybody help my out?

Thank you!

Re: Time intervals in front end

sunny_talwar — Thu, 04 Aug 2016 13:11:45 GMT

Does this look right?

Re: Time intervals in front end

sunny_talwar — Thu, 04 Aug 2016 13:29:09 GMT

Slight improvement of code here:

LOAD ID,

Date2,

Time2,

Date1,

Time1,

City

FROM

[test (2).xlsx]

(ooxml, embedded labels, table is Sheet1);

Time:

LOAD Interval(TimeStamp(MakeDate(Year(Today(1)), Month(Today(1)), Day(Today(1)) + Floor(RecNo()/24)) + MakeTime(Mod(RecNo(), 24))) - Today(1)) as Time

AutoGenerate 30;

Re: Time intervals in front end

MindaugasBacius — Thu, 04 Aug 2016 13:38:57 GMT

Looks perfect!

Thank you a lot.

Re: Time intervals in front end

sunny_talwar — Thu, 04 Aug 2016 13:49:54 GMT

No problem at all