10 Replies Latest reply: Apr 5, 2017 7:40 AM by Elizabeth Viso

# Division calculation in Qlik Sense

Hello

I have a table that shows the amount of inspections done per room and I need to calculate the percentage done based on it if passed or not.

So for the "Dated"  inspections there was 3 in total and only 2 passed, so it's 2/3 = 67% which I wrote out the expression like this:

Count({<Dated={'Yes'}>}Dated)/Count([Unit])

*Count the total Dated inspections that = yes and / it by the count of units

I'm getting 100% but I know it should be 67%. Any ideas?

Thanks!!

• ###### Re: Division calculation in Qlik Sense

Do you have Dated as a dimension?? May be this in that case

Count(Dated)/Count(TOTAL <FirstDimensionHere> [Unit])

• ###### Re: Division calculation in Qlik Sense

Hi,

Try like below,

Count({<Dated={'Yes'}>}Dated)/Count(Total [Unit])

• ###### Re: Division calculation in Qlik Sense

I tried this one also, still getting 100%

• ###### Re: Division calculation in Qlik Sense

Is Dated your dimension where you are trying to calculate this?

• ###### Re: Division calculation in Qlik Sense

I was just trying your suggestion, yes  Dated is a dimension. Does that make a difference?

Thank you as always for your help!

• ###### Re: Division calculation in Qlik Sense

Try this in that case

Count(Dated)/Count(TOTAL <FirstDimensionHere> [Unit])

or

Count(TOTAL {<Dated={'Yes'}>}Dated)/Count([Unit])

Replace FirstDimensionHere with whatever other dimension you have in your chart

• ###### Re: Division calculation in Qlik Sense

Assuming you have 2 dimensions (Dim1, Dated), you can try this

Count(Dated)/Count(TOTAL <Dim1> [Unit])

Assuming you have 3 dimension(Dim1, Dim2, Dates), you can try this

Count(Dated)/Count(TOTAL <Dim1, Dim2> [Unit])

• ###### Re: Division calculation in Qlik Sense

Hi,

Can you share your app with mock data. Thanks

• ###### Re: Division calculation in Qlik Sense

Hi,

Sample posted,

Sales/ total sales:

sum(Sales)/sum(TOtal Sales)

Sales/ Group by Country Sales Total:

sum({<write u r sets here>}Sales)/sum(TOtal <Country>Sales)

• ###### Re: Division calculation in Qlik Sense

Thank you Devarasu, that helped and it's working!

Now my only thing is that I'm showing too much information in my table. I'm showing the amount passed to be able to show the percentage. What I did was this: Count({<Dated={'Yes'}>}Dated)/Count(Unit) for the Dated % which is perfect but I'd rather not have to have the Dated Passed column. Is there a way to do that or am I just doing all of this wrong .