Histogram Chart

[sudhir0538]

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.

.

[swuehl · Accepted solution]

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)

[sudhir0538]

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?

[swuehl]

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)

[sudhir0538]

Yah.. Thanks a Ton Mr.Swuehl.

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