Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

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

Highlighted
Contributor III
Contributor III

Thank you!