Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
saurabha
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

Labels (1)
0 Replies