Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Daily Budget Phasing

Hi guys

Currently we only phase our budget monthly. But we look at our sales figures on a daily basis.

Is there a way I could load a monthly budget into Qlikview and it will divide the total monthly budget between all the working days in that specific month.

The result will be that I could compare daily sales vs daily budgets and also could see how we are doing Month to date.

Help will be appreciated.

Regards

2 Replies
Not applicable
Author

Hi

Has anyone got a solution for to how allocate a monthly budget to all the networkdays (working days) in a specific month?

Thanks

elpmasjj
Contributor II
Contributor II

This may, or may not, help you depending on the complexity of what you are trying to achieve.

Assuming DateId is the PrimaryKey in your Calendar table

Sum(BudgetValue) / Day(MonthEnd(DateId))