Score if greater than % revenue

[chloemartin]

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

[sunny_talwar · Accepted solution]

May be this

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

[chloemartin]

Thanks Sunny - worked like a dream!