How do you get the bars in a histogram to be between tick marks?

[#1]

Hi,

This is a follow up to the file created here: http://community.qlik.com/message/435162#435162

A histogram was built and I want to bars to be between the value marks and not on them, as is customary with histograms. Can you help?

Thanks

[swuehl]

I don't think that is feasible with QV, the labels will be shown under the bars (as this is just a standard bar chart, not a kind of specialized histogram chart).

But you can change your labels for the bins to show the range, not only the min value, like

Bins:

LOAD Min, Max, Min &'-'& Max as Bin INLINE [

    Min, Max

    0, 49.99

    50, 99.99

    100, 149.99

    150, 199.99

    200, 249.99

    250, 299.99

    300, 349.99

    350, 399.99

    400, 449.99

    450, 499.99

    500,

];

[#3]

thanks. I actually used the other format suggested, the one with expressions not with script loads

[Clever_Anjos]

Try to duplicate your bar expression and mark the new one as transparent.

It´s not exactly centered, but maybe can fit your need

[#5]

cute idea i hope there's a better way though.

thanks!

[Clever_Anjos]

Another trick

Replace your dimension to a calculated one

=Repeat(' ',20) & Dim2

[#7]

Hi,

The dimension is already a calculated dimension

=ValueList('0','50','100','150','200','250','300','350','400','450','500')

I tried to add another calculated dimension with

=Repeat(' ',20) & Bins

(bins is the label name I gave the above calculated dimension), but no success. I got a 'bad field name' notice

[Clever_Anjos]

try

ValueList('           0','               50','                    100','                150','             200','             250','              300','         350','         400','         450','            500')

[#9]

as the new dimension or instead of the original?

thanks

a

[Clever_Anjos]

replace your dimension

=ValueList('0','50','100','150','200','250','300','350','400','450','500')

with

ValueList('           0','               50','                    100','                150','             200','             250','              300','         350','         400','         450','            500')