Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
chloemartin
New 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

Re: Score if greater than % revenue

May be this

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

2 Replies

Re: Score if greater than % revenue

May be this

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

chloemartin
New Contributor

Re: Score if greater than % revenue

Thanks Sunny - worked like a dream!