Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
@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
Hi Sue, it's for Qlik Sense. Thanks! Lisa
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
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
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])