Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

harleen_singh
Contributor III

Plot Values Inside Segments and total in bar chart

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

1 Solution

Accepted Solutions

Re: Plot Values Inside Segments and total in bar chart

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 2nd Expression

TICK BOTH

Value on Data Point in expression tab

Invisible

12 Replies
Siva_Sankar
Honored Contributor

Re: Plot Values Inside Segments and total in bar chart

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

sujeetsingh
Honored Contributor III

Re: Plot Values Inside Segments and total in bar chart

Se this

brijesh1991
Contributor III

Re: Plot Values Inside Segments and total in bar chart

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

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

MVP
MVP

Re: Plot Values Inside Segments and total in bar chart

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

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 2nd Expression

TICK BOTH

Value on Data Point in expression tab

Invisible

Not applicable

Re: Plot Values Inside Segments and total in bar chart

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

Not applicable

Re: Plot Values Inside Segments and total in bar chart

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??

Not applicable

Re: Plot Values Inside Segments and total in bar chart

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

Not applicable

Re: Plot Values Inside Segments and total in bar chart

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!!!

Community Browser