Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

aetingu12
Contributor

Day count in set analysis

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

 

Labels (2)
2 Replies
Support
Support

Re: Day count in set analysis

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

Re: Day count in set analysis

May be this

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