Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for
Did you mean:
Creator III

## Relative in a stacked chart: relative to only the dimension value, not total

Hi, I'd like a stacked bar chart to show the % of calls from each dimension values, relative to the higher hierarchy dimension, not to the total of that specific dimention.

I would like the % to represent the % of the month, not the whole dimension.

Ex: the value for SAÉ for november is 473, the total for Externes is 404, for a total of 877.

So % should be 53.9% and 46.1% respectively.

How should I structure my data to make it possible?

1 Solution

Accepted Solutions
Creator III
Author

Well I found something in the meanwhile:

What I didn't specify in the first post was that I had two dimensions: Month and Call_type

and two expressions:

sum({<Avaya.Type_appel ={'Avaya.Externes','Avaya.SAÉ'}>} Avaya.Montant)

and another that failed, but this one did the trick:

=sum({<Call_Type ={'Avaya.Externes','Avaya.SAÉ'}>} Avaya.Montant)
/
sum({< Call_type ={'Avaya.Externes','Avaya.SAÉ'} >} total <Month> Avaya.Montant)

The first shoed a bar, the second none. Both had values on the axe, and on the presentation tab had both options ticked for presenting values withing segments and always showing the total.

Creator III
Author

Well I found something in the meanwhile:

What I didn't specify in the first post was that I had two dimensions: Month and Call_type

and two expressions:

sum({<Avaya.Type_appel ={'Avaya.Externes','Avaya.SAÉ'}>} Avaya.Montant)

and another that failed, but this one did the trick:

=sum({<Call_Type ={'Avaya.Externes','Avaya.SAÉ'}>} Avaya.Montant)
/
sum({< Call_type ={'Avaya.Externes','Avaya.SAÉ'} >} total <Month> Avaya.Montant)

The first shoed a bar, the second none. Both had values on the axe, and on the presentation tab had both options ticked for presenting values withing segments and always showing the total.

Community Browser