topic Daily Budget Phasing in QlikView https://community.qlik.com/t5/QlikView/Daily-Budget-Phasing/m-p/214775#M68279 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>Currently we only phase our budget monthly. But we look at our sales figures on a daily basis.</P><P>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.</P><P>The result will be that I could compare daily sales vs daily budgets and also could see how we are doing Month to date.</P><P>Help will be appreciated.</P><P>Regards</P></BODY></HTML> Tue, 07 Dec 2010 07:29:40 GMT 2010-12-07T07:29:40Z Daily Budget Phasing https://community.qlik.com/t5/QlikView/Daily-Budget-Phasing/m-p/214775#M68279 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>Currently we only phase our budget monthly. But we look at our sales figures on a daily basis.</P><P>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.</P><P>The result will be that I could compare daily sales vs daily budgets and also could see how we are doing Month to date.</P><P>Help will be appreciated.</P><P>Regards</P></BODY></HTML> Tue, 07 Dec 2010 07:29:40 GMT https://community.qlik.com/t5/QlikView/Daily-Budget-Phasing/m-p/214775#M68279 2010-12-07T07:29:40Z Daily Budget Phasing https://community.qlik.com/t5/QlikView/Daily-Budget-Phasing/m-p/214776#M68280 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Has anyone got a solution for to how allocate a monthly budget to all the networkdays (working days) in a specific month?</P><P>Thanks</P></BODY></HTML> Wed, 08 Dec 2010 14:52:33 GMT https://community.qlik.com/t5/QlikView/Daily-Budget-Phasing/m-p/214776#M68280 2010-12-08T14:52:33Z Re: Daily Budget Phasing https://community.qlik.com/t5/QlikView/Daily-Budget-Phasing/m-p/214777#M68281 <HTML><HEAD></HEAD><BODY><P>This may, or may not, help you depending on the complexity of what you are trying to achieve.</P><P></P><P>Assuming DateId is the PrimaryKey in your Calendar table</P><P></P><P>Sum(BudgetValue) / Day(MonthEnd(DateId))</P></BODY></HTML> Sun, 05 Jun 2016 23:50:23 GMT https://community.qlik.com/t5/QlikView/Daily-Budget-Phasing/m-p/214777#M68281 Anonymous 2016-06-05T23:50:23Z