topic Re: Bar Chart Data in % in QlikView

Bar Chart Data in %

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have two dimensions, country, and type of business.

I am trying to show data as percentage.

I would like to have for Spain, for one part 51% and the other 49%.

I have tried clicking on relative, however it is giving me the percentage not by country but of the total.

i hope you can help me.

sunny_talwar — Tue, 09 May 2017 12:32:43 GMT

Try this

Sum(Measure)/Sum(TOTAL <Country> Measure)

Anonymous — Tue, 09 May 2017 12:47:01 GMT

hello,

Originally, i have this expression, COUNT(total{$<SEGMENT={'PLANE'}>}SHARE).

doing what you told me it is not working however i think that is more that i haven´t written well the expression.

COUNT(total{$<SEGMENT={'PLANE'}>}SHARE).

COUNT(total{$<SEGMENT={'PLANE'},COUNTRY>}SHARE).

sunny_talwar — Tue, 09 May 2017 12:49:13 GMT

You had this as expression?

Count(TOTAL {$<SEGMENT={'PLANE'}>}SHARE)

or this

Count({$<SEGMENT={'PLANE'}>}SHARE)

May be try this

Count({$<SEGMENT={'PLANE'}>}SHARE)/Count(TOTAL <Country> {$<SEGMENT={'PLANE'}>}SHARE)

Anonymous — Tue, 09 May 2017 12:53:16 GMT

It worked perfectly