Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
aetingu12
Creator
Creator

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
Brett_Bleess
Support (Former)
Support (Former)

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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
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%')