comparison between actual and budget

[#1]

Hi Everyone,

I have a question that we have a budget for one month and actual amount is only 15 days , I want to compare the actual vs budget

then I'm not able to understand that how will compare . Please anyone suggest me how to compare actual and budget amount .

I 'm learning qlikview so please help me .

Thanks in advance.

[MK_QSL]

You can find out the Daily Budget (i.e Budget divided by no of working days)

Consider that you have Budget is 2000 and No of working Days in March is 20,

so daily budget is 100.

Now find out the no of working days already covered in this month.

Let they are 5 days.

So the actual budget now is 100*5 = 500

Let's your actual is 600 til date

Now your variance = (600-500)/500

[#3]

Hi

please try this code.

replace the year with month

({<Year={$(=Max(Year))}>} [Actual]) 

({<Year={$(=Max(Year))}>} [Budget) 

thanks

Michael

[MK_QSL]

to find out predicted actual ... you can do the same thing by finding daily actual...

i.e. Let Daily Actual = Total Actual / No of working days passed

Now Actual Prediction = Daily Actual * No of working days left in this month

Comparison = (Actual Prediction - Budget)/Budget

The same MTD scenario you can use in YTD also.

[#5]

Hi manish,

Thank u so much for the fast reply here I'm not getting that how the actual is 600 . Please can u explain me .

[MK_QSL]

This is assumed that you have actually 600 till date this month.