topic Re: Weighted average between dates in QlikView

Weighted average between dates

haribabugv — Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

I am trying to find the weighted average between two dates for Class A inside a text box. Can you please let me know how to modify this below expression.

if(date(Date) >= '$(vStart)' and date(Date) <= '$(vEnd)',Sum(Aggr(Sum(Actual * Quantity)/Sum(Actual))))

In another text box, i am trying to use max weighted average (Class A,Class B) between vStart and vEnd.

Sample Data:

Message was edited by: Hari Babu Added Sample data set and sample file

tresB — Fri, 21 Sep 2018 06:51:59 GMT

Try to share a sample qvw with inline/excel data and explain the expected output. That way you help us help you better.

haribabugv — Fri, 21 Sep 2018 07:12:56 GMT

I have just added it

tresB — Fri, 21 Sep 2018 07:29:04 GMT

Like this? PFA