Budget values not coming in Pivot

[saurabha]

Hi,

I am new to QlikSense and need to integrate budget with actual.

Actually I have been given Budget and Actuals Branchwise.

Budget is given on Yearly basis(Fiscal Year)  and Actual is present in data on daily basis.

Firstly, I  need to show data Quaterwise Budget V/s Actual.

Secondly, If actual for particular branch is not present then atleast its budget should be displayed(like Goa and mumbai in below example).When I am trying to display that the whole branch where Actual is not present is not been shown.

Expected Output:

Branch	Q1	Q2	Q3	Q4
	Budget	Actuals	Budget	Actuals	Budget	Actuals	Budget	Actuals
goa	125		125		125		125
gujrat	150	122	150	112	150	78	150	76
maharashtra	175	150	175	125	175	98	175	74
delhi	200	88	200	91	200	79	200	88
lucknow	225	90	225	75	225	96	225	135
nagpur	237.5	45	237.5	63	237.5	135	237.5	145
mumbai	250		250		250		250

 Thanks in advance