Question about Histogram when the bin width is open

[#1]

Hi folks, evening!

I am new using QlikView and I need to create a Histogram with the follows bins;

[2,291]

(291,581]

(581,871]

(871,1161]

(1161,1451]

(1451,1741]

(1741,2031]

(2031,2321]

(2321,2611]

>2611

I am working with this open amplitude because of the nature of my data.

I am attaching an image of the Histogram on Excel as a guide.  On excel I had 10 bins and a bin width of 290 approximately.

Could you give some help?

[Siva_Sankar · Accepted solution]

Hi Jaime,

Need sample data for this. Otherwise, you can refer here Recipe for a Histogram

or refer here Re: How to do a histogram?

Siva

[Anil_Babu_Samineni]

This excel image showing simple Bar Chart with Continuous option from axes Tab. Here, when you talk about Histogram you may attach sample data or Follow the first link which Siva shared

[#4]

Hi Anil,

Thank you, I am following you. Regarding the first link which Siva shared, If on Excel my bin width is 290, is this the number that I need type in the input box in the step number 2 of this link?

[#5]

Thank you, Siva.

[Anil_Babu_Samineni]

Even, If you write or enter the Value it will change once you used the same variable for formula in Bar Chart