Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

Add two types of percentage calculation together in one measure on a bar chart

Hi

Using Qlik Sense

I am trying to Add two types of percentage calculation together in one measure on a bar chart

The dimension is calendar year

I currently have two percentage measures on the bar chart

the calculations look like

e.g

count({$<SectorID={"1"}, OrderCompleted = {"Yes"}>}SectorID) / count({$<SectorID={"1"}>}SectorID)

but I wish to add / combine this second calculation percentage as one measure on the bar chart

sum({$<SectorID={"20"}>}FinalSaleValue) / sum({$<SectorID={"20"}>}OverallSaleValue)

I have tried with no joy encapsulating the vales

(count({$<SectorID={"1"}, OrderCompleted = {"Yes"}>}SectorID) / count({$<SectorID={"1"}>}SectorID)) +

(sum({$<SectorID={"20"}>}FinalSaleValue) / sum({$<SectorID={"20"}>}OverallSaleValue))

please help

12 Replies
joeybird
Creator III
Creator III
Author

Hi

that pic is the result I am getting when trying to add the two percentage  expressions together

sunny_talwar

Can you show me when they are not added up please

joeybird
Creator III
Creator III
Author

Hi

I have manage to get this to work,

the issue was that it cannot add up two % when one sum is based on "count" and the other is "Sum"

but thanks team. x