Hi
In Qlik Sense, a stacked bar chart will by default show the net sum of the measures. That is, it will add up the positive values and subtract the negative ones for each stack in the chart. If you want to show the absolute sum (ignoring the sign), you need to adjust your expression to handle this logic.
Here's how you can modify the measures to achieve this:
-
Create new measures: Instead of using the original measures directly, create new calculated measures that take the absolute value of your measures. For example, if your original measures are Measure1 and Measure2, you would create new measures as follows:
Try...
Abs(Measure1)
Abs(Measure2)
-
Total Expression: When adding the total label in the bar chart, you might need to use an expression to calculate the total as the absolute sum of Measure1 and Measure2. This can typically be done in the chart's properties panel where you define the total.
Try...
Sum(Abs(Measure1)) + Sum(Abs(Measure2))
-
Custom Formatting: To customize the format of the total value, you can use the Num() function in Qlik Sense within your expression to format the number as you want. For example:
Try...
Num(Sum(Abs(Measure1)) + Sum(Abs(Measure2)), '#,##0.00')
This will format the number with a comma as a thousand separator and two decimal places.
Here's an example of how you can implement this in a chart expression:
// Assuming your dimension is called 'Dimension'
Sum({<Dimension>} Abs(Measure1)) + Sum({<Dimension>} Abs(Measure2))
And for the custom total label, you can use the Num() function as described above.
Keep in mind that customizing the total label's format might not always be straightforward in the Qlik Sense UI, as it often automatically formats numbers based on the overall chart settings. If the default UI options do not meet your needs, you might have to resort to using a Qlik Sense extension that allows for more customized total labels.
