Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!