Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator II
Creator II

Actual V/S budget v/S forecasting in one report

Hi Team, 

Please find below the datatset:-

So here my data source is SAP

I need to show this report in qliksense using the same below  format. However,i do not know how create "Actuals" , "Budgeted" flag at the backend and how to show this at the front end. Kindly help .

 

[PAR/WBS, April till  Actuals should come under the heading "Actuals"] and again [April to Budget should come under the heading "Budget"]

FY20CountryWBS element DescriptionPAR / WBS Element AprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarch Actuals AprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarch Budget 
CapitalCZ01CAD REFRESH PC907190-1                          
CapitalIN01PRECISION 7520 CAD LAPTOP907310-1                  3000       
2 Replies
anushree1
Specialist II
Specialist II

How about split and join the table like below:

Load 

fy-20,

...,

PAR / WBS Element,

Jan,

....

Dec,

'Actual' as Flag

From <<Table Source>>

inner Join

Load 

fy-20,

...,

PAR / WBS Element,

Jan,

....

Dec,

'Budget' as Flag

From <<Table Source>>

 

Please make sure to load actual data months in the first load set and in the second load the other set of Months which are or Budget

Aspiring_Developer
Creator II
Creator II
Author

Thank you for your response. 

 

Could you please tell me if we can use crosstable for  months ?