Hi everyone,
I'm pretty new to Qlik and I have a question regarding how to map some data (call times) on a continuous range (whether the data exists or not).
As you can see in the following link the data "13:00" is not shown in the graphic - it's because there are no call at this specific time.
My question is how can I make it happen without injecting fake data (where a call would happen at 13:00).
https://i.imgur.com/7LfGiMC.png
I'm currently trying a solution which is creating a Dimension of my Time_Range and add as a measure a string cast of my call_times : =Text(right(TS,8))
Unfortunately the cast doesn't seem to go well :
https://i.imgur.com/IHWTIf6.png
Let's say we have some call times :
calls:
Load *,
Timestamp(Timestamp#(String)) as TS ;
LOAD * INLINE [
String
2015-09-15T08:05:00
2015-09-15T08:23:00
2015-09-15T08:49:00
2015-09-15T09:05:00
2015-09-15T11:22:00
2015-09-15T16:33:00
2015-09-15T15:57:00
2015-09-15T10:05:00
2015-09-15T10:35:00
2015-09-15T11:05:00
2015-09-15T11:35:00
2015-09-15T14:05:00
2015-09-15T14:28:00
2015-09-15T15:32:00
2015-09-15T15:35:00
2015-09-15T16:05:00
2015-09-15T16:35:00
2015-09-15T17:24:00
2015-09-15T17:35:00
2015-09-15T18:05:00
];
Time_Range:
LOAD * INLINE [
String
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
];
I can't figure out a way to merge those two in a graphic
If anyone has a clue of how to do such a thing, please let me know,
Thanks,
N