topic Re: How do you get the bars in a histogram to be between tick marks? in QlikView

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

Thu, 12 Dec 2013 10:53:14 GMT

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

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

swuehl — Thu, 12 Dec 2013 11:57:27 GMT

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,

];

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

Thu, 12 Dec 2013 12:23:25 GMT

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

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

Clever_Anjos — Thu, 12 Dec 2013 12:33:33 GMT

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

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

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

Thu, 12 Dec 2013 12:37:35 GMT

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

thanks!

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

Clever_Anjos — Thu, 12 Dec 2013 12:53:47 GMT

Another trick

Replace your dimension to a calculated one

=Repeat(' ',20) & Dim2

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

Thu, 12 Dec 2013 13:14:04 GMT

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

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

Clever_Anjos — Thu, 12 Dec 2013 13:24:52 GMT

try

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

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

Thu, 12 Dec 2013 13:31:42 GMT

as the new dimension or instead of the original?

thanks

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

Clever_Anjos — Thu, 12 Dec 2013 13:33:43 GMT

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')

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

Thu, 12 Dec 2013 13:38:03 GMT

The alignment is way off. Thanks for trying though!