Weighted Avg on a line graph-month on month trend

suhasarchak — Wed, 10 Dec 2014 03:28:17 GMT

Hi,

I have calculated the weighted average for a set of data in a pivot table and is coming correctly. Now, I wanted to present the same weighted average monthly trend in a line a graph, it is not populating the right values. I have attached the example.

When I use the same expression used in pivot table in the line graph to populate the weighted average on a month on month basis in a line graph, I am not getting the same values. Please see the pdf file for what values Qlik View is populating.

Formula used is

=sum({<LoanDate={"<=$(=max(LoanDate))"},LFY={"<=$(=max(LFY))"},LQtr=,LMonth=>}BalanceOS*WtAvgIntCostCalc)/

sum({<LoanDate={"<=$(=max(LoanDate))"},LFY={"<=$(=max(LFY))"},LQtr=,LMonth=>} BalanceOS)

Your help will be appreciated.

Thanks,

Suhas Archak

topic Weighted Avg on a line graph-month on month trend in QlikView

Weighted Avg on a line graph-month on month trend