Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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 )

View solution in original post

2 Replies

Re: Score if greater than % revenue

May be this

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

View solution in original post

chloemartin
New Contributor

Re: Score if greater than % revenue

Thanks Sunny - worked like a dream!