topic Re: Plot Values Inside Segments and total in bar chart in QlikView

Plot Values Inside Segments and total in bar chart

harleen_singh — Fri, 03 Jan 2014 09:22:56 GMT

Has anybody found the solution of showing values inside the 'Stacked Bar Chart' and also showing the Total on the top?

Re: Plot Values Inside Segments and total in bar chart

Siva_Sankar — Fri, 03 Jan 2014 09:38:01 GMT

To put values in the bars stacked in your Bar Chart :

For each expression, ,<tick> Values on Data Points
On Presentation tab, <tick> Plot Values Inside Segments

For Total Value above:

Create new expression to give Total Value number
<tick> Line
<tick> Values on Data Points
<tick> Invisible

Regards.

Siva

Re: Plot Values Inside Segments and total in bar chart

sujeetsingh — Fri, 03 Jan 2014 09:42:11 GMT

Se this

Re: Plot Values Inside Segments and total in bar chart

brijesh1991 — Fri, 03 Jan 2014 09:44:20 GMT

Go to expression tab: check "Values on Data points"

Go to presentation tab: check "Plot Values inside segment"

Re: Plot Values Inside Segments and total in bar chart

jagan — Fri, 03 Jan 2014 09:51:32 GMT

Hi,

Please find attached file for solution, if there are less number of segments then values are displayed in the segments, otherwise the values are not displayed in the segments.

Regards,

Jagan.

Re: Plot Values Inside Segments and total in bar chart

MK_QSL — Fri, 03 Jan 2014 09:57:22 GMT

You need to create two same expression

For 1st expression

TICK BOTH

Value on Data Points in expression tab

Plot values inside segments in presentation tab

For 2^nd Expression

TICK BOTH

Value on Data Point in expression tab

Invisible

Re: Plot Values Inside Segments and total in bar chart

Tue, 14 Jan 2014 20:07:15 GMT

I tried your method, however it did not work. Can you load an eg. Thanks.

Re: Plot Values Inside Segments and total in bar chart

Mon, 21 Jul 2014 08:38:17 GMT

Hi Harleen,

I have two dimensions(Date/Month,Category) and a Measure(Value), how do you achieve the same result. Can't go with as many expressions as catgories like

sum({<Category={'1'}>}Value) - bar chart - values inside segments

sum({<Category={'2'}>}Value) - bar chart - values inside segments

sum({<Category={'3'}>}Value) - bar chart - values inside segments ... and so on

total expression as

sum({<Category={'1'}>}Value)+sum({<Category={'2'}>}Value)+sum({<Category={'3'}>}Value)+... - values on data points and invisble option

here If Category values are known & fixed, can go with your method. Is there anyway if Category values are dynamic??

Re: Plot Values Inside Segments and total in bar chart

Thu, 07 Aug 2014 17:55:44 GMT

This will only work when you have two expressions, but if we have more than 1 dimension will not work.

Re: Plot Values Inside Segments and total in bar chart

Wed, 14 Oct 2015 10:56:34 GMT

I thank you sir you have helped me ALLOT, been struggling with this for almost 3 hours using a dual function but the damn thing just didnt want to show my % calculation.

THANK YOU!!!

Re: Plot Values Inside Segments and total in bar chart

chaper — Thu, 25 Feb 2016 20:20:44 GMT

Hi Jagan,

Have you ever seen Total on top and value inside segments working in Ajax and not working in IE ??.I have one expression only with both value inside segments and also show total on top options checked.It works fine in Ajax but not IE.

thanks

Re: Plot Values Inside Segments and total in bar chart

jagan — Fri, 26 Feb 2016 00:39:50 GMT

I am not sure, can you create a new thread and attach a sample file.

Regards,

Jagan.

Re: Plot Values Inside Segments and total in bar chart

Anonymous — Fri, 24 Mar 2017 07:05:55 GMT

Is there no workaround/alternative for this available? When 2 dimensions are to be used...