Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Check out our latest virtual session where BARC Fellow, Doug Laney, highlighted the opportunities data monetization can offer enterprises. Watch here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rougeherring
Contributor III
Contributor III

Multiply Values By Record Row - Set Analysis

I need to show a cumulative total based on multiplied values from two fields in a bar graph. 

I need to use set analysis to multiply each month's census * credits to come up with the cumulative target for each month. 

Unfortunately if I tell it to give me the months less than this month (Jan-July), sum (Census) * sum(Credits) it multiplies 1050 * 28 (29400) where as I need it to multiply and add each row independently to give me 4200. 

MonthCensus CreditsTotalCumulative Target
January1454580 
February14545801160
March15246081768
April15246082376
May15246082984
June15246083592
July15246084200
August15246084808
September15223045112
October15246085720
November15246086328
December15246086936

 

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this.

RangeSum(Above(TOTAL Sum([Census ]*Credits), 0, RowNo(TOTAL)))

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!