Score if greater than % revenue

chloemartin — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Score if greater than % revenue

sunny_talwar — Fri, 02 Feb 2018 16:59:41 GMT

May be this

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

Re: Score if greater than % revenue

chloemartin — Mon, 05 Feb 2018 10:15:14 GMT

Thanks Sunny - worked like a dream!

topic Re: Score if greater than % revenue in QlikView

Score if greater than % revenue

Re: Score if greater than % revenue

Re: Score if greater than % revenue