Bar Percentage

Salehmo — Mon, 06 Jul 2020 10:25:10 GMT

Dear all,

I have a data containing sales per distributor and i need to get a graph showing the contribution percentage from the total per each distributor as in the below graph as we do in excel pivot chart (show % from grand total)

Re: Bar Percentage

Taoufiq_Zarra — Mon, 06 Jul 2020 10:35:47 GMT

Hi,

If I underestood correclty, you need :

num(sum(Sales)/sum(total Sales),'# ##0%')

for exemple, with the below sample :

Data:
load * inline [
Row Labels,Sales
EIMC,10
ETC,20
ISBNSINA,30
MEC,40
MULTIPHARMA,50
Overseas,10
Sofico,60
UCP,70
];

In Interface:

Dimension: Row Labels

Measures : num(sum(Sales)/sum(total Sales),'# ##0%')

output :

topic Re: Bar Percentage in QlikView

Bar Percentage

Re: Bar Percentage