Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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.

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

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
Oleg Troyansky

Masters Summit for Qlik is going virtual! Dec 16th - I'll teach Performance Tuning