Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

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,

];

Highlighted
Not applicable

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

Highlighted
Employee
Employee

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

Highlighted
Not applicable

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

thanks!

Highlighted
Employee
Employee

Another trick

Replace your dimension to a calculated one

=Repeat(' ',20) & Dim2

bar2.png

Highlighted
Not applicable

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

Highlighted
Employee
Employee

try

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

Highlighted
Not applicable

as the new dimension or instead of the original?

thanks

a

Highlighted
Employee
Employee

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