# Water Cooler

This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for
Did you mean:
Not applicable

## value in the bar and sum on the bar

Hi all

I have this chart:

Is it possibile having the sum above every bar?

Luca

1 Solution

Accepted Solutions

Not in one chart, but you can get the totals below the bars. See attached example.

talk is cheap, supply exceeds demand
12 Replies
Specialist II

I do not think so since you have plot inside segments checked (can't have both), but you can put on axis by adding another expression and calculating the total that way, just check Text on Axis and Uncheck Bar chart:

Hope this helps!

Partner - Specialist

Hi,

You can add an other expression like :

Column(1)+Colunm(2)+Column(3)+Colunm(4)

and on the Display Options panel

uncheck Bar and check Values on Data Points

Best,

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!

Not in one chart, but you can get the totals below the bars. See attached example.

talk is cheap, supply exceeds demand
Specialist

If you want to put the values on the datapoint then

Right Click on graph--> Properties-->Expression-->Check field  Values on data point. It will display data above the graphs.

Not applicable
Author

thanks.

how I write the expression? could you post an axample?

luca

Specialist II

The expression would be the total of each of the 4 segments for your bar. Just add them together or sum them up, depends on your expression(s) for getting those numbers. How are you calculating now?

Hope this helps!

Not applicable
Author

in my chart, X-dimension is

=Pick( Match (left( Text(QuarterName([Ingresso Contract Analysis])),1), 'g','a','l','o'), '1Q ','2Q ','3Q ','4Q ') & right(Text (QuarterName([Ingresso Contract Analysis])),2)

how can I use this in a expression like "count(total <Month> Sales)"  ?

luca

Well, you can't. The sane way out of this is to create the quarter field in the script and then use it as dimension in your chart instead of that calculated dimension you have now. You can simply reuse the expression of your calculated dimension in the script to create that quarter field in the same table you load the field [Ingresso Contract Analysis].

talk is cheap, supply exceeds demand
Not applicable
Author

ok, thank you very much..

luca