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