Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"]
FY20 | Country | WBS element Description | PAR / WBS Element | April | May | June | July | August | September | October | November | December | January | February | March | Actuals | April | May | June | July | August | September | October | November | December | January | February | March | Budget |
Capital | CZ01 | CAD REFRESH PC | 907190-1 | ||||||||||||||||||||||||||
Capital | IN01 | PRECISION 7520 CAD LAPTOP | 907310-1 | 3000 |
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
Thank you for your response.
Could you please tell me if we can use crosstable for months ?