Convert monthly Budget to Daily Budget with set analysis

[LisaG]

Hi everyone,

goal of my report is to show the daily revenue compared with the daily budget of different customer, products, years, companies etc. (a lot of dimensions)

I have budget figures per month and a second table with workingdays per day (working day = 1, not working day =0). An example of the database you find in the excel.

I want to calculate a daily average budget and Qlik must show me for every day a figure.

=sum[budget] / sum[working day]

It gives me the average  monthly but the days are empty. An example you find in my excel.

I have a lot of dimensions for the budget figures, so if its possible to solve it with set analysis.

Can someone help?

Thanks,

Lisa

[Sue_Macaluso]

@LisaG Hi Lisa, Is this for Qlik Sense or View? I am not sure if its in the correct forum and Id like to get it to the correct one. Thanks

[LisaG]

Hi Sue, it's for Qlik Sense. Thanks! Lisa

[dplr-rn]

It should be possible but how to do it; lot depends on your chart and dimensions.

give a sample of table/chart you want.

Easiest thing maybe to create a daily budget in the data model itself.

please share a sample data 

[LisaG]

It's to complexe to create a data model itself.

I have monthly budget figures  per client, product, company code, currency, year. It's very detailed.

I need a table based on the date where I can compare the actual revenue figures with the budget.

In addition to the table I have different filters.

Sorry I cannot share a Desktop file, I have no desktop installed.

Thanks

[LisaG · Accepted solution]

Hi,

I could solve it with set analysis

(sum({<year={$(=year(today()))}>}total[net revenue])
/
sum({<year={$(=year(today()))}>}total[working days per month]))
*
sum({<%DAT={"<$(=today())"},year={$(=year(today()))}>}[working days])