topic Re: Question about Histogram when the bin width is open in QlikView

Question about Histogram when the bin width is open

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Question about Histogram when the bin width is open

Siva_Sankar — Tue, 11 Apr 2017 01:53:54 GMT

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

Re: Question about Histogram when the bin width is open

Anil_Babu_Samineni — Tue, 11 Apr 2017 05:01:31 GMT

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

Re: Question about Histogram when the bin width is open

Tue, 11 Apr 2017 13:28:17 GMT

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?

Re: Question about Histogram when the bin width is open

Tue, 11 Apr 2017 13:54:47 GMT

Thank you, Siva.

Re: Question about Histogram when the bin width is open

Anil_Babu_Samineni — Tue, 11 Apr 2017 16:04:35 GMT

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