Incomplete visualization in bar chart

hannessch — Sat, 16 Nov 2024 07:23:35 GMT

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.

Re: Incomplete visualization in bar chart

Oleg_Troyansky — Fri, 14 Dec 2018 07:42:53 GMT

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

topic Incomplete visualization in bar chart in App Development

Incomplete visualization in bar chart

Re: Incomplete visualization in bar chart