Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
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,

];

Not applicable
Author

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

Clever_Anjos
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

Not applicable
Author

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

thanks!

Clever_Anjos
Employee
Employee

Another trick

Replace your dimension to a calculated one

=Repeat(' ',20) & Dim2

bar2.png

Not applicable
Author

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
Employee
Employee

try

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

Not applicable
Author

as the new dimension or instead of the original?

thanks

a

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