topic Histogram in QlikView

Histogram

Mon, 11 Apr 2011 12:36:18 GMT

Hi Guys,

I see there are a few posts regarding this descriptive method of charting, but my lack of experience makes understanding what they're talking about very difficult LOL

Ok, so what I am trying to do is create a histogram for each fielditem that I have. On the Y axis will be the COUNT and on the x-axis my intervals that I have defined. I do not want QV to randomly choose how many intervals to use, I would like to define this myself and for QV to then determine the equal width of each interval.

Guys, as much detail and lamens terms as possible when explaining, I am very new to QV 🙂

Thanks,

Byron

Histogram

Mon, 11 Apr 2011 20:08:29 GMT

Did you try Class function ?

Class ( Variable , 5 ) give you interval with a step = 5.

If you know exactly the threshold of each bar, create an expression like this

If ( Var > x1 , '> x1' ,

if( Var > x2 , ' x2 to x1' , < x2 ) )

Histogram

Tue, 12 Apr 2011 09:58:04 GMT

Cheers, ended up using the class function and then a variable overview to allow a more dynamic range with regards to the number of intervals reported on.

Cheers man,

Byron