Qlikview cannot do a histogram that plots the frequency distribution of a numerical value.

Fri, 28 Nov 2014 10:16:02 GMT

Can it be true that Qlikview cannot do a histogram that plots the frequency distribution of a numerical value and draws the bars with a sensible width?

I have had a response from QlikTech support saying this is not a bug and is working as expected.

The histogram we need to have shows the frequency of a numerical dimension grouped into bin sizes and also plots the range of values leaving gaps where there are no values in that range.

The only way of doing this appears to be by;

selecting continuous on the x axis (dimension) so that it plots the range of data including the gaps in the values

using a dimension like Floor(value, $(vBinSize)) to group the numerical values together.

The trouble is as soon as I do this Qlikview has a bit of a fit and can't work out how wide the bars should be. The bar width can be anywhere from too wide and overlap/obscure each other, or so narrow they are hard to see and look ridiculous.

I've attached an example if there is anyone who may have any suggestions. Any suggestions for improvements/fixes would be very gratefully received.

Thanks Dave.

Re: Qlikview cannot do a histogram that plots the frequency distribution of a numerical value.

ThornOfCrowns — Fri, 28 Nov 2014 10:43:41 GMT

That is wierd!

The only way I can get something to show without overlapping is to use a symbol with an Error bar below. It's not the greatest thing in the world, but I cannot get it to work with Bars as you have found.

topic Qlikview cannot do a histogram that plots the frequency distribution of a numerical value. in QlikView

Qlikview cannot do a histogram that plots the frequency distribution of a numerical value.

Re: Qlikview cannot do a histogram that plots the frequency distribution of a numerical value.