Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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

10 Replies
MVP
MVP

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

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,

];

Not applicable

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

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

Employee
Employee

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

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

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

bar.png

Not applicable

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

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

thanks!

Employee
Employee

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

Another trick

Replace your dimension to a calculated one

=Repeat(' ',20) & Dim2

bar2.png

Not applicable

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

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

Employee
Employee

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

try

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

Not applicable

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

as the new dimension or instead of the original?

thanks

a

Employee
Employee

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

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

Community Browser