topic Re: Revenue vs Budget in QlikView

Revenue vs Budget

danimarc12 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Revenue vs Budget

FakeJupiter — Thu, 22 Oct 2020 10:49:06 GMT

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?

Re: Revenue vs Budget

danimarc12 — Fri, 23 Oct 2020 06:47:34 GMT

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

Re: Revenue vs Budget

Brett_Bleess — Wed, 04 Nov 2020 16:44:09 GMT

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/SetAnalysis/set-analysis-expressions.htm

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

Re: Revenue vs Budget

danimarc12 — Mon, 09 Nov 2020 14:59:41 GMT

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!