CODEWITHSUNDEEP
qlikview
Nina PRO
Nina PRO

Reputation: 91

TOTAL in bar chart in qlikview

I have this graph chart bar in Qlikview, the expression is: 

INTERV= Sum(Quantity)/Count(Number)

and we can see the total for the first period is: 3450.76, i want to manipulate the total so as to calculate the total for each segment: the first segment is A: 192.70. I did Sum(TOTAL<Segment> INTERV) but it doesn't work to have the total I obtain 0 .

Your help is very apprciated

Thank you

enter image description here

Upvotes: 1

Views: 2137

Answers (1)

Chris J
Chris J

Reputation: 936

Are you looking for a total for each value? In this instance it would not be possible as Qlikview is removing the text that it cannot show as the sections are too small.

You can increase the chart size so the overall area is larger, remove the stacking option or I would suggest having a separate Table chart to display these values alongside your graph.

Here are the options that can configure the different totals

For each category within a month (as you have at the moment) you enable this option. enter image description here

Whilst to only have the total per month, this is on the expression tab. enter image description here

Upvotes: 1

Related Questions