Solved: TimeLine chart with Multiple events - Qlik Community

BTIZAG_OA · ‎2022-12-21

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.156622...

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.

justISO · ‎2022-12-21

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.

View solution in original post

justISO · ‎2022-12-21

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.

BTIZAG_OA · ‎2022-12-21

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?

TimeLine chart with Multiple events

General Question