Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

2 Replies
Not applicable
Author

Not sure if this would work based on your requirement:

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

Not applicable
Author

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.