Solved: Count in Bar Chart Legend - Qlik Community

Anonymous · ‎2017-01-09

Hi,

Is it possible to show the count of values in a bar chart legend? Something like the following

Thanks,

Sunny

girirajsinh · ‎2017-01-09

Hi

So earlier I suggested to put each individual expression and then put count in label for each. But if you don't want to go that way and you have many departments to show,

I guess something like following would help. Lets see if that gives you desired result.

eg. you have

then change the dimension to calculated as following

should get you this result

View solution in original post

dsharmaqv · ‎2017-01-09

can you please give more details

Kushal_Chawda · ‎2017-01-09

Nothing is there in following.

Anonymous · ‎2017-01-09

something like this, not sure if the image is visible

Anonymous · ‎2017-01-09

added the image

Anonymous · ‎2017-01-09

added the image

girirajsinh · ‎2017-01-09

Hi Sunny

If you have limited legends or fixed legends to show then it is possible , as following

lets say you have bar chart like

Then you will have to create expression for each Year legend individually.

Once you have that, you can put count or other calculation in its label

As shown here,

I hope this would help you.

Anil_Babu_Samineni · ‎2017-01-09

Boss, If you have only one Expression you can't make legend in Bar Chart.

Come to Bulk Expressions, You need to paste the Same Expression into Label and then Show what ever you want

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-01-09

Thanks Giri,

I was able to get this pretty easily in a pie chart using the presentation tab in properties. But I can't find that function in the bar chart.

Any simpler way of showing the count?

I need to show the count of issues by department and year, e.g. HR has 10 issues, IT 20 issues, etc. and I have it in a stacked chart. Thoughts?

Thanks

MindaugasBacius · ‎2017-01-09

But there is no calculations in the legend?

Or do you wish result on data points?

Count in Bar Chart Legend

Related Topics