topic Re: normalizing in a bar chart in QlikView

normalizing in a bar chart

Anonymous — Fri, 10 Jul 2015 14:03:04 GMT

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

Re: normalizing in a bar chart

MK_QSL — Fri, 10 Jul 2015 14:07:52 GMT

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

Re: normalizing in a bar chart

awhitfield — Fri, 10 Jul 2015 14:10:59 GMT

Hi Larisa,

see if the attached helps

Andy

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

Re: normalizing in a bar chart

MK_QSL — Fri, 10 Jul 2015 14:16:16 GMT

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...

Re: normalizing in a bar chart

Anonymous — Fri, 10 Jul 2015 15:20:23 GMT

Thank you!