topic Re: Re: Description inside a bar in the bar chart in QlikView

Description inside a bar in the bar chart

Sun, 03 Nov 2013 22:49:45 GMT

How can I generate this graph in QlikView?

More specifically, how can I generate the percantage of the entire population (red rectangle in the image)?

Thanks!

Re: Description inside a bar in the bar chart

vivientexier — Sun, 03 Nov 2013 22:56:34 GMT

Add another expression to calculate your percentage then ask QlikView to show the result as "values on data points" and uncheck "bar" ("expression" tab in your chart properties).

On "presentation" tab, check "plot values inside segments".

Re: Description inside a bar in the bar chart

preminqlik — Mon, 04 Nov 2013 03:37:11 GMT

add same expression another time and make sure it as relative and also check the box it is invisible ....

for help please follow below link

http://community.qlik.com/docs/DOC-3939

regards

premhas

Re: Description inside a bar in the bar chart

Mon, 04 Nov 2013 08:39:10 GMT

Thank you for your replies.

I am having trouble with getting the same output.

In addition, here is how my table looks like:

Tbl:

LOAD * INLINE [
Year, Region, Amt, Pct
2012, WE, 104, 25.3
2012, EE, 81, 19.3
2016, WE, 250, 59.8
2016, EE, 223, 52.7
];

I have noticed in your document that second expression is as "Line" marked. In my case that option is not available (I can´t click on it because it is faded.). How can I make it a line expression?

One more question - how can I add "%" sign to expression?

Re: Re: Description inside a bar in the bar chart

preminqlik — Mon, 04 Nov 2013 13:50:01 GMT

according to my knowledge it is possible in this way...

find attachment

...

regards

Premhas

Re: Re: Description inside a bar in the bar chart

Mon, 04 Nov 2013 14:20:12 GMT

Thanks for your reply!

Sorry, but I can't find the attachment.
Furthermore, I have found out why I could not select "Line" for the second dimension - I was using bar chart and I needed to use combo chart.

I hope your attachment answers my other questions.

Re: Re: Description inside a bar in the bar chart

Mon, 04 Nov 2013 14:24:48 GMT

If you were referring to the previously sent QVW, could you please generate the same chart by talking the inline table I sent?
I was having troubles generating bars with different colors.
I still have problems with setting percentage inside the middle of the bar, and adding "%" sign to the amount of percentage.

Re: Re: Description inside a bar in the bar chart

Mon, 04 Nov 2013 15:28:27 GMT

I would like to know also if it is possible to display every value in the stacked bar.
For example, if in bar chart I have three different values stacked on top of one another to form one bar in the bar chart, is it possible to display in the middle of every part the corresponding value? If yes, please how?

Re: Re: Re: Description inside a bar in the bar chart

Carlos_Reyes — Wed, 06 Nov 2013 22:06:42 GMT

Using a bar chart you cannot replicate the same format you have in your image. You can place values only on top or inside the bars, however if you have more than one expression, all values will be on top or inside, you cannot choose different places for each plotted expression.

What you can do is

Place one expresion values in the X axis
Do not plot the second expression and place its values on top or inside the bars, Or show the values only as a popup.

Review the attached.

Also, if you create a stacked chart, you cannot force all values to be shown since this depends on whether each part is big enough so that the text is shown. I haven't found a workaround to solve this.