Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
that pic is the result I am getting when trying to add the two percentage expressions together
Can you show me when they are not added up please
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