Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

MindaugasBacius
Valued Contributor II

Time intervals in front end

Hei.

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

I do have a data table like:

Screenshot_1.jpg

The expression is like this:

Screenshot_3.jpg

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:

Screenshot_2.jpg

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

Could anybody help my out?

Thank you!

Tags (2)
1 Solution

Accepted Solutions

Re: Time intervals in front end

Does this look right?

Capture.PNG

4 Replies

Re: Time intervals in front end

Does this look right?

Capture.PNG

Re: Time intervals in front end

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;


Capture.PNG

MindaugasBacius
Valued Contributor II

Re: Time intervals in front end

Looks perfect!

Thank you a lot.

Re: Time intervals in front end

No problem at all

Community Browser