Revenue vs Budget

[danimarc12]

Hi guys! I'm a Qlikview learner and I've been "working" with this software for 2 months. I took a view of the Qlikview guide and also of this forum but I didn't find what I was looking for. Basically, as you can see from the images, I want to calculate the % of my revenue compared to my budget in a period. As I wrote, this expression works if I don't select any filter, so it works in the year (Max(Anno)) but, when I select in my filters a month or a week or any period, my expression doesn't work anymore. Could anyone help me?

ps. in my expression:
- Anno = Year(data01)  where "data01" = date_field
- netto = revenue
- Budget = input box (€)

I hope I've been clear, for further informations, please text me!

[FakeJupiter]

I don't have a solution, as I don't quite understand the expression.

Can someone explain to me what sort of set expression is that with "$" sign after the first opened curly bracket?

[danimarc12]

Hi! basically my formula has to be: (revenue + budget of the rest of the days) / budget total.

I have datas from the 2018 so I want to calculate the revenue of 2020

[Brett_Bleess]

I believe you may need the following info:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Sorry I do not have something better, but hopefully it may put you on the right track.  If you want to search further in the Design Blog area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[danimarc12]

Hello Brett! thanks for the links. I wrote it correctly, btw my problem is still the same.

Is it possible to have one expression which calculates it in every period I select? I know it's not very easy but if someone can help me I'll be very grateful!