topic Creating a Histogram in Sense... help please! in App Development

Creating a Histogram in Sense... help please!

rebostero — Fri, 02 Dec 2016 13:53:11 GMT

Hi all!

I'm new to Qlik and to programming, so I'm still getting my feet wet here. I am trying to create a histogram based on 2 fields in my data - Revenue & Target. What I'm trying to create is a histogram for the frequencies of the ratio Revenue/Target=Attainment. This is how my table is organized

ID	Quarter	Revenue	Target
12345	1	100	120
12345	2	150	89
34567	1	200	125
34567	2	130	345
34567	3	500	1250

I need to set the bins at intervals of 5% (or 10%) and know the count of the attainment (Revenue/Target) for that range. I assume that filtering out globally an ID, a Quarter or another field will modify the histogram accordingly.

I've tried looking at other postings but I'm not being able to translate them to my reality. Any assistance will be very welcome.

Thanks

Re: Creating a Histogram in Sense... help please!

sunny_talwar — Fri, 02 Dec 2016 16:15:36 GMT

Histogram in QlikView or Qlik Sense should be the same. Have you tried taking a peek here: Recipe for a Histogram

Re: Creating a Histogram in Sense... help please!

rebostero — Fri, 02 Dec 2016 18:06:10 GMT

Hmmm I saw that one but for example, no input box that I'm aware on Sense....

Re: Creating a Histogram in Sense... help please!

sunny_talwar — Fri, 02 Dec 2016 18:37:39 GMT

May be an extension:

Qlik Branch

Re: Creating a Histogram in Sense... help please!

rebostero — Fri, 02 Dec 2016 18:38:58 GMT

Solved, thank you. Much simpler than the other examples, I was over complicating it - just used class in the dimension and then counted normally, worked perfectly