Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
May be this
Num(Sum({<SUMMARY_DATE>} Interest_Rate) /Sum({<SUMMARY_DATE>} Average_Balances) * (360/Day(Max({<SUMMARY_DATE>} SUMMARY_DATE))), '#,##0.00%')