normalizing in a bar chart

[Anonymous]

Hi,

My bar-chart has two dimensions Brands and Media and it is based on the expression sum(FieldName). As a result I can see media distribution inside each brand (see the file attached). The bars are the brands im my example.

I need two normalize it. I need to set 100% for each brand so that brands (bars) could be of the same height.

How can I do it?

Thank you in advance,

Larisa

[MK_QSL]

You need to use Total Qualifier. What are the Dimension and Expression for this chart?

[awhitfield]

Hi Larisa,

see if the attached helps

Andy

https://community.qlik.com/thread/13284

[MK_QSL · Accepted solution]

Dimension

1) Field1

2) Field2

Expression

SUM(YourFactField)/SUM(TOTAL <Field1> YourFactField)

Untick Values on Data Points

SUM(Sales)

Untcik Bar

Tick Values on Data Point

Style STACKED

Hope this helps...

[Anonymous]

Thank you!