Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sunnysahni
Contributor

Count in Bar Chart Legend

Hi,

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

Thanks,

Sunny

1 Solution

Accepted Solutions
girirajsinh
Contributor III

Re: Count in Bar Chart Legend

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

21 Replies
dsharmaqv
Contributor III

Re: Count in Bar Chart Legend

can you please give more details

Re: Count in Bar Chart Legend

Nothing is there in following.

sunnysahni
Contributor

Re: Count in Bar Chart Legend

something like this, not sure if the image is visible

sunnysahni
Contributor

Re: Count in Bar Chart Legend

added the image

sunnysahni
Contributor

Re: Count in Bar Chart Legend

added the image

girirajsinh
Contributor III

Re: Count in Bar Chart Legend

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.

Re: Count in Bar Chart Legend

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

sunnysahni
Contributor

Re: Count in Bar Chart Legend

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
Valued Contributor II

Re: Count in Bar Chart Legend

But there is no calculations in the legend?

Or do you wish result on data points?

Community Browser