Discussion Board for collaboration on QlikView Scripting.
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?
Does this look right?
View solution in original post
Slight improvement of code here:
(ooxml, embedded labels, table is Sheet1);
LOAD Interval(TimeStamp(MakeDate(Year(Today(1)), Month(Today(1)), Day(Today(1)) + Floor(RecNo()/24)) + MakeTime(Mod(RecNo(), 24))) - Today(1)) as Time
Thank you a lot.
No problem at all