Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

Budget values not coming in Pivot

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:

BranchQ1Q2Q3Q4
 BudgetActualsBudgetActualsBudgetActualsBudgetActuals
goa125 125 125 125 
gujrat1501221501121507815076
maharashtra1751501751251759817574
delhi20088200912007920088
lucknow225902257522596225135
nagpur237.545237.563237.5135237.5145
mumbai250 250 250 250 

 

 

 Thanks in advance

Tags (1)
Labels (1)