Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hannessch
Partner - Contributor
Partner - Contributor

Incomplete visualization in bar chart

Hi There Qlik Community,

I'm struggeling with an bar chart visualization in Qlik Sense.

I have a list of tasks with a start and end time. And I want to display the duration of each task in a bar chart. So I display a bar for each minute a single task is 'opened'.

Dimension: MasterTime

Meassure: =Sum(if(StartTime <= MasterTime  and MasterTime <= EndTime,1,0))

This works fine. But i have an issue with the visualization:

When I try to show the tasks of a whole day (whole_day.png) data is missing.

When I just display the data of one hour (one_hour.png) all tasks are shown. Especially when you have a look on the peak (for the whole day there are 5 parallel tasks and for the hour view there are 8.

And when I view the data for one unique task (one_task.png) all the data is shown too.

I suspect that there are some issues with the amount of data. But all in all for one day there are 2652 bars that should be displayed. That seems not to be too high, am I right?

Does anybody had similar problems and do you know how to solve this issue.

Labels (1)
  • Chart

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Sorry if this is too late for this issue...

I'd try to round the MasterTime field to one minute level or even more, in order to reduce the number of bars in the chart.

Cheers,

Oleg Troyansky