topic TimeLine chart with Multiple events in App Development

TimeLine chart with Multiple events

BTIZAG_OA — Wed, 21 Dec 2022 07:57:10 GMT

Hello everyone,

I have a data like this;

load * Inline
[
ProcessName,Start,Duration
x,01:00,00:30
y,05:00,02:00
z,01:30,10:00,
x,05:00,00:45
]

i want to show ProcessName on Y axis and 24hrs on x axis and duration on the bars. ,

I achieved this with the following instructions on stacked barchart

https://help.qlik.com/en-US/video/DUcz3q4wf6k?_ga=2.189871403.1631716967.1671542848-116271152.1566226109

but is it possible to show the same processname that runs twice in a day on this chart?

i need to show x seperately first run for 30min and second run for 45min and between that hours should be colored white.

Re: TimeLine chart with Multiple events

justISO — Wed, 21 Dec 2022 08:56:08 GMT

Hi, one thing I know in such situation is to add something what distinct your rows, in this case ProcessName. If same name process starts at different hour, you can try something like this:

=ProcessName &' ('& hour(Start) & ')'

Other way would be in load script add additional dimension: row number in table:

RowNo() as row

and use row dimension as process distincter.

Re: TimeLine chart with Multiple events

BTIZAG_OA — Wed, 21 Dec 2022 10:03:14 GMT

Hello JustISO,

RowNo() as row this worked well 🙂 at leas i can show each run on dimension.

Is it possible to show multiple events on same bar?