Discussion board where members can get started with QlikView.
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,
Go to Solution.
May be this
if( ((SUM(Revenue)) ) / ( (SUM(total <Company> Revenue)) ) >0.05,1,0 )
Thanks Sunny - worked like a dream!