8 Replies Latest reply: Aug 3, 2017 9:16 AM by Arvind Kumar Jha

Percentage in Bar Chart

Hello Team,

I have a simple query which i will explain through sample data :

 Geography Sales US 90 UK 70 APAC 30 MEA 10

The requirement is to create a bar chart in Qliksense with below parameters :

Dimension : Geography

Measure : Sales

Current we can enable data points on bar chart which shows the values but we want percentage contribution to be shown besides it like say for US : 90(45%) ,UK : 70(35%) etc etc.

Any help regarding same is highly appreciated.

Thanks & Regards,

Arvind Kumar Jha

• Re: Percentage in Bar Chart

Hi Arvind,

Use this

Sum({<>} Sales) / Sum(Total{<>} Sales) and make Number Format as % in dimention properties

Regards,

• Re: Percentage in Bar Chart

To my knowledge you are unable to do that in qlik sense (control the hover text).  you could create a second measure for the calculation but then would have to have two bars on the chart.

• Re: Percentage in Bar Chart

I am sorry, i read it wrong. You can use my expression in color by expression option it will give you two measures together.

Hope thos helps.

Regards,

• Re: Percentage in Bar Chart

I created a master measure and wrote the above formula but it did not work.

Thanks,

Arvind

• Re: Percentage in Bar Chart

Hi,

Try this in dimension,

=Geography

&':'&aggr(sum(Sales),Geography)&'('&num(aggr(sum(Sales),Geography)/aggr(sum(all Sales),Geography),'##%')&')'

Regards,

• Re: Percentage in Bar Chart

Hello Lakshmipathi,

The above calculation is correct but when taken as dimension it increases the length of each value of dimension and values are at bottom.

Basically we want value at top something like below value and percentage side by side and geography name at bottom:

• Re: Percentage in Bar Chart

Hi Arvind ,

Sum(Sales) / Sum({1} Sales)   Number format select % in measures

Thanks,

Arvind Patil

• Re: Percentage in Bar Chart

Hi,

Please use Sum(Sales)/Sum(Total Sales) expression in chart measure and change the number format as %.it will give you the expected output.