Qlik Sense App Development

Contributor II

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))

12 Replies
MVP

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

If you add them as two different expressions, do you see the bars next to each other?

Contributor II

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

Hi

when I have two expressions (as two separate measures) I do have two separate bars in the graph

I wish to combine the percentage totals together as one bar in the graph..

the issue I think I can see is one percentage is worked out as count and the other is sum, hence why I have tried encapsulating it..

kind regards

MVP

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

I am not sure I am able to understand what you are having. I don't think count % and Sum% should have any problem getting added up. Can you at least share some snapshots where you have both of them as a separate expressions in a bar chart or table?

Contributor II

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

Hi

that's what I thought , encapsulating always works when doing charts with e.g

(count ({<Country={"USA"}>}ID) / count (ID)) +

that's why I think there is an issue with using a count and a sum

MVP

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

Can try to help if you share a sample. Out of ideas

Contributor II

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

hi

and my two measures are

Measure one

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

Measure two

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

I wish to combine measure 1 and 2 in one measure

MVP

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

I don't see any bar, do you?

Contributor II

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

when I do it as separate measures I do

when I try and do this

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

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

just gives me the above