Day count in set analysis

[aetingu12]

Dear all,

I have a bar chart with an expression using set analysis where I calculate interest rates as such:

num(sum({<SUMMARY_DATE = >}Interest_Rate)/sum({<SUMMARY_DATE=>}Average_Balances)*(360/Day(SUMMARY_DATE)),'#,##0.00%')

Basically, I want to multiply the Interest/Average by the respective months day count.  This gives me only the last month, due to the Day(SUMMARY_DATE).  how do I change it to make it so that it picks each month.

Any help is more than appreciated.

Regards,

Aksel

[Brett_Bleess]

Aksel, best I have is the following Design Blog post on dates and set analysis:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

It will likely help if you can attach a sample QVW on this one.

Regards,
Brett

[sunny_talwar]

May be this

Num(Sum({<SUMMARY_DATE>} Interest_Rate) /Sum({<SUMMARY_DATE>} Average_Balances) * (360/Day(Max({<SUMMARY_DATE>} SUMMARY_DATE))), '#,##0.00%')