Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
chloemartin
Contributor
Contributor

Score if greater than % revenue

 

Hi Qlik experts, I’m really stuck.

I’m looking to create a scoring system to count products (only greater than 5% Revenue) by company.

 

This is my IF statement:

if( ((SUM(Revenue)) ) / ( (SUM(total Revenue)) ) >0.05,1,0 )

 

   

 

This works great when I look at just one company (above screenshot), but if I include more companies this totals all the company revenue and skews the score for each company. 

 

How do I apply this to count how many products (greater than 5% Revenue) per company?

 

 

Thanks in advance,

 

Chloe

 

 

1 Solution

Accepted Solutions
sunny_talwar

May be this

if( ((SUM(Revenue)) ) / ( (SUM(total <Company> Revenue)) ) >0.05,1,0 )

View solution in original post

2 Replies
sunny_talwar

May be this

if( ((SUM(Revenue)) ) / ( (SUM(total <Company> Revenue)) ) >0.05,1,0 )

chloemartin
Contributor
Contributor
Author

Thanks Sunny - worked like a dream!