topic Re: Day count in set analysis in QlikView

Day count in set analysis

aetingu12 — Sat, 16 Nov 2024 02:10:41 GMT

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

Re: Day count in set analysis

Brett_Bleess — Wed, 30 Oct 2019 14:43:01 GMT

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

Re: Day count in set analysis

sunny_talwar — Wed, 30 Oct 2019 14:58:12 GMT

May be this

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