topic Re: Help with Chart in QlikView

Help with Chart

Anonymous — Tue, 26 Jan 2016 16:26:41 GMT

Hi All

I am tasked with creating a Bar chart with age range

so Dimensions are days 0-20, 21-40, 41-60 etc

And it counts how many tickets are open

My question is how do i go about this?

Re: Help with Chart

sunny_talwar — Tue, 26 Jan 2016 16:28:36 GMT

Use a calculated Dimension using Class function and a simple Count function for counting field in each bucket. Would you be able to to share a small sample to help you better?

Re: Help with Chart

erivera10 — Tue, 26 Jan 2016 16:31:47 GMT

Hi,

Use master calendar, that's the best practice.

Best regards,

Erivera10‌

Re: Help with Chart

swuehl — Tue, 26 Jan 2016 16:32:56 GMT

Have a look at

Recipe for a Histogram

Buckets‌

You can probably use something like

=Class( AgeField, 20)

as calculated dimension and

=Count( AgeField)

as expression.

Re: Help with Chart

sunny_talwar — Tue, 26 Jan 2016 16:39:33 GMT

See if the attach helps

Re: Help with Chart

Anonymous — Tue, 26 Jan 2016 17:17:47 GMT

Sunny Thanks for your help!

Any ideas how to change the Labels on the bottom?

so it says 0-20, 21-40 etc?

Currently saus 0>x=20... etc