Report last Years Sales for the upcoming Month

[dominikkeller]

Hey,

i want to print a Report (with the build in Report Editor) and show last Years Sales for the upcoming Month.

So far so good. My Problem is, i need to loop the Page over the Weekdays. In this case he ignores my expression and gives me the Sales for the actual Month.

Without the Weekday Selection

The Output tooks the right Month but is not calculated based on a weekday.

With the Weekday i get the right Weekday but the wrong Month

I guess i need a new field in my calender but im not really sure how to solve it?

Any ideas?

[dominikkeller]

This is the field in the calander

[Brett_Bleess]

Best guess would be you may need a master calendar, here is a Design Blog link to that topic:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

Will likely need to attach a sample QVW on this one to get further help too, as difficult to offer up suggestions without being able to see the data model and expressions...

Regards,
Brett