Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
nina_jensen
Contributor III
Contributor III

Dividing count with sum?

Hi,

I have a table that lets say shows salesmen, month, sales and reasons for sale. If sale has happened it is stated with 1 - if not it says 0.

Reasons are counted as these are stated with text. In the last colum I want to show the percentage of sales by dividing with reason, but I can't get this working. Either the result is 0%, 100% or even higher

In the Sales dimension there is a expression calculating sales for the selected month;

Sum({1<sales ={"1"},[Month]=p([Month])>}sales)

In the Reason dimension there is a expression counting reasons

Count(reasons)

SalesmenMonthSalesReasonsPercentage
JohnJAN200599,97%
DaveJAN5050100,00%
MaryJAN1001099,90%
KateJAN1502099,86%
1 Solution

Accepted Solutions
sunny_talwar

Is this not working?

1 - (Count(reasons)/Sum({1<sales ={"1"},[Month]=p([Month])>}sales))

View solution in original post

4 Replies
sunny_talwar

So what are the expected numbers that you are looking to get?

nina_jensen
Contributor III
Contributor III
Author

Oops - sorry, was a little bit late yesterday!

The output I want is Reasons/Sales-100%

I have updated the table.

sunny_talwar

Is this not working?

1 - (Count(reasons)/Sum({1<sales ={"1"},[Month]=p([Month])>}sales))

nina_jensen
Contributor III
Contributor III
Author

Hi Sunny,

Thank you ever so much! This was the correct input

Regards

Nina