Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Prevent Overlapping bars or uncentered bars in bar chart histogram

I created a histogram for a dimension in Qlikview. X-axis is the percentile, and I want to show frequency of percentiles to represent performance for certain key measures. If there is greater frequency toward the right, closer to 90th percentile, this indicates good performance. When there is greater frequency to the left, closer to 10th percentile, this indicates poor performance.

When different dimensions are chosen, I want the x axis to remain the same even if there isn't data for all x-axis values (Qlikview default is to only show the x-axis values if there is data). To do this, I selected Continuous in the Axes tab under x-axis. This works for most measures.

clipboard_image_0.png

However, I've noticed two issues:

Issue 1: If there is data only for a single value, only that percentile will appear centered on the x-axis and the corresponding bar will appear un-centered:

Example 1:

clipboard_image_2.png

Example 2:

clipboard_image_3.png

Issue 2: If only a few percentiles have data, the axis remains the same but the bars become very wide and overlap. Here the data label "5" for 70th percentile is blocked by the wide bar for 60th percentile.  

clipboard_image_1.png

How can I prevent these two issues??

2 Replies
Highlighted
Contributor II
Contributor II

FYI these are the Axes selections:

clipboard_image_0.png

Highlighted
Digital Support
Digital Support

Katherine, the best I have for you is the following link, hopefully it may give you something to help here, but my response will kick things back up in the queue again, so maybe someone new will see things and have another idea as well.

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Histogram/ba-p/1462688

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.