topic Re: Count in Bar Chart Legend in QlikView

Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 08:09:17 GMT

Hi,

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

Thanks,

Sunny

Re: Count in Bar Chart Legend

dsharmaqv — Mon, 09 Jan 2017 08:19:08 GMT

can you please give more details

Re: Count in Bar Chart Legend

Kushal_Chawda — Mon, 09 Jan 2017 09:00:00 GMT

Nothing is there in following.

Re: Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 09:29:37 GMT

something like this, not sure if the image is visible

Re: Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 09:29:54 GMT

added the image

Re: Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 09:30:02 GMT

added the image

Re: Count in Bar Chart Legend

girirajsinh — Mon, 09 Jan 2017 09:32:22 GMT

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

Anil_Babu_Samineni — Mon, 09 Jan 2017 09:37:34 GMT

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

Re: Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 10:31:43 GMT

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

Re: Count in Bar Chart Legend

MindaugasBacius — Mon, 09 Jan 2017 10:44:11 GMT

But there is no calculations in the legend?

Or do you wish result on data points?

Re: Count in Bar Chart Legend

girirajsinh — Mon, 09 Jan 2017 10:50:28 GMT

so you are not looking for something like

When you mentionedd Stack chart, I am wondering how/where do you want to put numbers in it?

Re: Count in Bar Chart Legend

MindaugasBacius — Mon, 09 Jan 2017 10:52:54 GMT

I am guessing:

Re: Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 10:58:06 GMT

I tried that, it's a stacked chart, it just gives me the total of all the departments, I need to show it next to the department like in the pie chart I put up above

Re: Count in Bar Chart Legend

Anil_Babu_Samineni — Mon, 09 Jan 2017 11:01:14 GMT

Strange, Can you send you application to work on it. If the file size is large then you make reduce size and then share with us it demonstrates the Output

1) Have you created Label for Numbers on each expressions ?

Re: Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 11:11:24 GMT

sorry I can't send the application, it's confidential.

I just have 1 expression which is Count(Issue)

Dimensions are Year and Department

Stacked bar chart

I did something similar in pie chart and was able to get the count easily. Am I missing something?

Re: Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 11:12:42 GMT

This works too, how did you get this?

I just have 1 expression which is Count(Issue)

Dimensions are Year and Department

and it's a stacked bar chart

Re: Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 11:13:23 GMT

I just want the count in the legend like it shows

Re: Count in Bar Chart Legend

girirajsinh — Mon, 09 Jan 2017 11:18:26 GMT

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

Re: Count in Bar Chart Legend

Anil_Babu_Samineni — Mon, 09 Jan 2017 11:42:33 GMT

When you say you are trying for Pie Chart you should do this to show Numbers, I mean share only scramble data. You may go ahead and create one file for Us and then it will show the issue for Sure always

Please check which i high-lighted the below image

Re: Count in Bar Chart Legend

Anonymous — Mon, 09 Jan 2017 11:45:24 GMT

Thanks Giri,

This is what I wanted. Just curious how did you get the following numbers in the bars