topic Stacked bar - data values in segments and total in QlikView

Stacked bar - data values in segments and total

ljdlumley — Fri, 24 Apr 2015 15:54:10 GMT

Hi everyone,

probably a simple one but it has been a long week. I've got a stacked bar chart showing percentages of responses to a question. Each segment has the value shown inside, if the segment is large enough. What I'd like to have is another expression showing the number of respondents to the question. I basically want to see that English had 35 people, Music 120 and so on. I've tried adding another expression and can get it to come up in the pop up but I want to add it to the chart. It looks like you can't have one expression with values inside and one with values outside.

Any ideas would be gratefully received.

thanks

John

Re: Stacked bar - data values in segments and total

buzzy996 — Fri, 24 Apr 2015 15:59:34 GMT

see tis, and don't forgot to check values on data points from expression tab also.

Re: Stacked bar - data values in segments and total

anbu1984 — Fri, 24 Apr 2015 16:29:58 GMT

Check this app

Re: Stacked bar - data values in segments and total

ljdlumley — Mon, 27 Apr 2015 08:30:10 GMT

Thanks for your reply Shiva. I know how to get the percentages to plot inside the bars, see my original post, but what I also want is a value outside the bar showing the number of people. In this screenshot I've just created a text object to show what I want but this isn't a final solution as the number of departments will change depending on other filters.

John

Re: Stacked bar - data values in segments and total

ljdlumley — Mon, 27 Apr 2015 08:32:12 GMT

Thanks Anbu,that might be a work around but what I really wanted was a total number for the department, not the number with each answer within the department. Where the segment is small the numbers don't show so my end users can't see how many people answered the question.

John