
Contributor
2018-02-02
06:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
980 Views
1 Solution
Accepted Solutions

MVP
2018-02-02
11:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
if( ((SUM(Revenue)) ) / ( (SUM(total <Company> Revenue)) ) >0.05,1,0 )
2 Replies

MVP
2018-02-02
11:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
if( ((SUM(Revenue)) ) / ( (SUM(total <Company> Revenue)) ) >0.05,1,0 )

Contributor
2018-02-05
05:15 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Sunny - worked like a dream!
899 Views
