Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ferchops1987
Partner - Contributor II
Partner - Contributor II

How to show total of a stacked bar chart

Hi everyone,

I searched it in several post but i didn't found how to solve my problem. Actually, I am not able to display the total of a stacked bar chart, it repetes the result as many times as values of dimensions there are. I want to show just one.

The expression is (It corresponds for the result in gray):

num(
sum(TOTAL <"Periods"> {<[_ContractedProjectFlag]={1}>}[Project volume])
,$(vU.Format.0D)
)

Periods: cycle dimension which contains some dimensions relative to dates.

Capture.PNG

I would appreciate so much any help

Thanks,

8 Replies
Anonymous
Not applicable

On the presentation tab untick Plot Values Inside Segments.

Or you could tick Still Show Total on Top so you get it both by dimension and the total.

ferchops1987
Partner - Contributor II
Partner - Contributor II
Author

Hi Bill,

I want to have both values, by dimension and the total. The problem is whether I tick <Still Show Total on Top>, I do not know how to format this value. I am using variables to be able to transform the numeric format, using num() function and a list box which allows to do the selection of format. What ever, if I put it manually in the number tab, I lose this dynamism.

Some idea to achieve it?

Thank u very much.

rupamjyotidas
Specialist
Specialist

Why not use Text as Pop up to help you out

Probably the link below will help you

Define Your Pop-Ups

kkkumar82
Specialist III
Specialist III

What is the number format of your expression, I think your number format should be "Expression default"

ferchops1987
Partner - Contributor II
Partner - Contributor II
Author

I am using a variable which contains calculated dimensions for the first expression (Two option in this case). The same for the second one.

ferchops1987
Partner - Contributor II
Partner - Contributor II
Author

Hi Rupam,

Finally I do it, because I think there is no way to deploy what I want...

Capture20161018-1.PNG

As you can see I can format the number in the pop up, but I can not in the graph.

Thank you.

Not applicable

Hi ferchops1987‌ , could you post the solution, we just migrated to QV12, and suddenly it's repeating the values.

Would like to know how you solve it.

Many thanks

ferchops1987
Partner - Contributor II
Partner - Contributor II
Author

Hi Martin,

I am using Combo Chart, so in the tab Expressions I've chosen "Values on Data Points" and then in the Presentation tab in the "Values on Data Points"...

Untitled.png