Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Count if with aggr

I am trying to find the number of customers whose profit percentage is more than 50%

Basically, count the number of customers whose (Profit/Total) > 50%

What I tried is as follows but did not work:

SUM(Aggr(IF(Profit/TotalSale>0.5,1,0),Customer))

Suggestions please.

1 Solution

Accepted Solutions
Highlighted

Might make sense to throw a distinct in there also

Count(DISTINCT {<customer = {"=Sum(Profit)/Sum(TotalSale) > 0.5"}>} customer)

View solution in original post

4 Replies
Highlighted
Partner
Partner

Try as follow:

Count({<customer= {"=sum(Profit)/sum(TotalSale>0.5"}>} customer)

Highlighted
Specialist III
Specialist III

Hi,

Small correction in Omar expression:

Count({<customer= {"=sum(Profit)/sum(TotalSale)>0.5"}>} customer)

Highlighted
Partner
Partner

what have u corrected?

the missing ) in sum(totalSale) ?

Highlighted

Might make sense to throw a distinct in there also

Count(DISTINCT {<customer = {"=Sum(Profit)/Sum(TotalSale) > 0.5"}>} customer)

View solution in original post