Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lain_
Contributor III
Contributor III

How to Graph SumProduct of Columns

I have a pivot table in the qvw file linked below. Is there anyway to do the sumproduct I show in the excel file? I copied the pivot table from qvw file to the excel sheet. What I want is the table to the right in the excel sheet but in QlikView and to eventually put this in a graph (the table isn't as important, what needs to be shown is the graph, the table is an intermediate step to get to the graph). Is there anyway to do this in QlikView?

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum(Aggr((Sum({$<b = {0.25, 0.5, 0.75, 1}>} val) / Sum({$<b={0.25, 0.5, 0.75, 1}>} total <month, a> val)) * Only({$<b={0.25, 0.5, 0.75, 1}>} b), a, b, month))

View solution in original post

2 Replies
sunny_talwar

Try this

Sum(Aggr((Sum({$<b = {0.25, 0.5, 0.75, 1}>} val) / Sum({$<b={0.25, 0.5, 0.75, 1}>} total <month, a> val)) * Only({$<b={0.25, 0.5, 0.75, 1}>} b), a, b, month))
lain_
Contributor III
Contributor III
Author

Thank you!