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