Prevent Overlapping bars or uncentered bars in bar chart histogram

Katherine — Sat, 16 Nov 2024 20:06:40 GMT

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.

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:

Example 2:

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.

How can I prevent these two issues??

Re: Prevent Overlapping bars or uncentered bars in bar chart histogram

Katherine — Mon, 09 Sep 2019 21:49:47 GMT

FYI these are the Axes selections:

Re: Prevent Overlapping bars or uncentered bars in bar chart histogram

Brett_Bleess — Mon, 23 Sep 2019 15:19:09 GMT

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

topic Re: Prevent Overlapping bars or uncentered bars in bar chart histogram in QlikView

Prevent Overlapping bars or uncentered bars in bar chart histogram

Re: Prevent Overlapping bars or uncentered bars in bar chart histogram

Re: Prevent Overlapping bars or uncentered bars in bar chart histogram