Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
TKendrick20
Partner - Specialist
Partner - Specialist

Sum values of each segment in bar chart

Attached is a chart where values (Count of segment * Score for that segment) are displayed within each segment of the chart. However, is there a way to get the total of all segment values at the end of the bar?

Thanks in advance.

QlikView Chart.PNG.png

8 Replies
MK_QSL
MVP
MVP

Yes, kindly upload your sample file..

TKendrick20
Partner - Specialist
Partner - Specialist
Author

I only have QlikView PE.

The bar size is determined by:

Count({$<[Question Number] = {'5'}>} DISTINCT [Respondent ID])

The data values are determined by:

SUM({$<[Question Number] = {'5'}>} [Answer Value]) * Count({$<[Question Number] = {'5'}>} DISTINCT [Respondent ID])

MK_QSL
MVP
MVP

I need data also. Without I can't work on your file...

even though you have PE, once will found solution, will give your expressions.

Not applicable

You can achive this by creating a second expression which creates the total. Follow the below steps.

1. Create a second expression using AGGR function. If you have 2 dimension in yor graph year and month then the expression would read as 'aggr(sum(Actuals),Month)

2. Enable the 'Value of data point' property for this expression.

Hope these steps help?

TKendrick20
Partner - Specialist
Partner - Specialist
Author

Not effective, the AGGR function does not seem to be helpful in this case

Not applicable

It is working for the sample dashboard that I have created.

I should be able to help if you post your sample QVW,...

TKendrick20
Partner - Specialist
Partner - Specialist
Author

TKendrick20
Partner - Specialist
Partner - Specialist
Author

SUM({$<[Question Number] = {'7'}>} total <[Question Text]> [Answer Value])

Bolded is the crucial part of this calculation that allows for the calculation of the total of all segments.