topic Expression help needed to multiply 2 fields per record and sum the total in QlikView

Expression help needed to multiply 2 fields per record and sum the total

Thu, 02 Dec 2010 03:03:05 GMT

I have a set of records that I am filtering out by a status and date. For each record then, I have a score (just the value of a field) and a count of the days the record is active (expression to count a field). In a separate chart or text box, I am trying to create an expression that would multiple the score x the count of active days per record. Then I want to sum that value for all records and divide by the total number of active days. I am able to calculate the total number of active days, but I am having a problem getting a SUM of (Score x # Active Days per record).

Any suggestions?

Expression help needed to multiply 2 fields per record and sum the total

Thu, 02 Dec 2010 06:56:28 GMT

Not sure if this would work based on your requirement:

(sum(TOTAL (<Score> * <Active Days>))) / <Active Days>

Expression help needed to multiply 2 fields per record and sum the total

Thu, 02 Dec 2010 15:43:18 GMT

I didn't have luck with this one. I have attached an example QVW with the expected results noted that I am trying to get.