topic Re: Histogram Chart in QlikView

Histogram Chart

sudhir0538 — Wed, 25 Nov 2020 16:16:04 GMT

Hello all!

In my chart,I have 4 fields. J1, J2,J3 AND Avg(J1+J2+J3)(Graph-1).J1 ,2 and 3 are fetching from the database and Avg is calculated value.

There's necessity of creating a histogram chart(in qlikview) for the avg values(created in excel Graph-2). How many no of samples have been there for a particular avg range(say between 20-40 ,40-60). Range was not a problem.

Not getting any idea to implement.

Anyone have any idea please help.

Re: Histogram Chart

swuehl — Mon, 13 Jun 2016 11:56:50 GMT

Maybe have a look at

Recipe for a Histogram

Maybe like using a calculated dimension

=Round(Aggr( Avg(J1+J2+J3), RecordIDFIELD),20)

and as expression

=Count( RecordIDFIELD)

Re: Histogram Chart

sudhir0538 — Tue, 14 Jun 2016 05:17:10 GMT

Hello Swuehl

This was really solved my issue.Now I got another problem. I am unable to do grouping in the graph. I want to give the user to choose the range and based on the selected range the graph'll shows the data for only selected fields. like this

How do I implement the same in my histogram graph?

Re: Histogram Chart

swuehl — Tue, 14 Jun 2016 08:49:12 GMT

Try creating a list box with a field expression (from field drop down, select <expression>) like

=Aggr( Round(Aggr( Avg(J1+J2+J3), RecordIDFIELD),20), RecordIDFIELD)

Re: Histogram Chart

sudhir0538 — Wed, 15 Jun 2016 05:53:43 GMT

Yah.. Thanks a Ton Mr.Swuehl.

Really we'll create wonders by using AGGR() function. Thanks a lot.