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