topic Re: Budget vs actuals in QlikView

Budget vs actuals

Sat, 05 Jan 2013 04:15:26 GMT

dear friends,

i hope u r doing well i have following isssue

that is i have budget figures for sector wise they have given summeraised values

now i want to convert that values for whole data and i want one gauge chart with speedo metre

like if i select month,year then budjet vs actual will reflect

i have samle data pls see the attchment

if u able to answer it would help me lot

Thanks&Regards,

chandu

Re: Budget vs actuals

khadeer — Sat, 05 Jan 2013 04:29:00 GMT

Hi RAM,

we didnt get any values in attached excel sheet, u have budget figures sector wise, what about actual values.

Re: Budget vs actuals

Sat, 05 Jan 2013 05:03:14 GMT

Sorry,

Pls see the attachment

Re: Budget vs actuals

Sat, 05 Jan 2013 05:07:20 GMT

This is my Requirement

For budget tracking, have a speedo chart on

- The guage chart will show Actual
divded by Budget (%)

- Chart will be green or red based on
budget figure pro-rated for no of days (for e.g. if we are looking at Dec end
figures, we will compare actuals with budget for nine months - which is total
budget / 12 multiplied by 9)

Re: Budget vs actuals

khadeer — Sat, 05 Jan 2013 05:35:54 GMT

How i can identify which r actual n which r budget.

Re: Budget vs actuals

nirav_bhimani — Sat, 05 Jan 2013 06:58:36 GMT

HI,

For distinguish between budget and actual you have to add field in the link table budget data and transactional data (Actual Data). You have to create a link table for that.

'Transaction' as Source, // In ur transaction link table

'Budget' as Source, // // In ur budget link table

Then with the help of this expression you can find the budget vs sales in gauge chart.

sum({<CalendarDate = {">=$(=num(Yearstart(max({<Source = {'Transaction'}>}CalendarDate),0,4)))<= $(=num(max({<Source = {'Transaction'}>}CalendarDate))) "},

CalendarWeekOfYear=,CalendarQuarter=,MonthName=,CalendarYear=>}Sales)

(sum(Budget))

Hope this will help you.

Regards,

Nirav Bhimani

Re: Budget vs actuals

Sat, 05 Jan 2013 07:49:09 GMT

hai neerav

i have summeraised budjet for four sectors and acctuals for that four sector

now requirement is i need to split that budget amount to all calender selection

Re: Budget vs actuals

nirav_bhimani — Sat, 05 Jan 2013 08:13:54 GMT

Hi,

Please share the snapshot of that so that it would be more clear.

Regards,

Nirav Bhimani

Re: Budget vs actuals

Fri, 13 Jun 2014 12:27:08 GMT

Hello Nirav Bhimani,

I like to analyse the Target and Current Revenue.Below is the scenario,

Current Revenue per month- 80,000

My target -1,00,000

Travelling Expenses-10,000

Electricity Charges -3000

Other Expenses -1000.

My Questions is that:

I have a Gauge Chart where One end will display the Current Revenue and opposite will display the Target which I want to achieve.i have three slider control in which Travelling expenses amount,Electricity charges amount and Other Expenses amount are assigned.

If i decreases the Expenses in slider, then automatically my Current Revenue have to increases and

should moves to the target.How can i do this.Give me the code to do it.Please help me.