Month Status set to Actual or Forecast

[#1]

I have an application that is pulling in monthly data (all CROSS TAB data) - where the values are either ACTUAL or BUDGET (2 different sets of data).  In the ACTUAL data - the months that have already past (like Jan & Feb) are really ACTUALS and the remaining months are truly a FORECAST.

To reflect this difference, I want to setup a 'STATUS' of the month - meaning if Jan & Feb actuals have been posted to be able to show those months as 'Actuals' and the remaining months (Mar-Dec) set as Forecast.  I setup an excel spreadsheet (see below) with the first column being MONTH and the second column being STATUS (which is either Act or Fcst for Actual or Forecast).  I have tried to make this connection in Qlikview, but it isn't working properly.

Does anyone have any suggestions to help me?  Thank you for any help you can offer.  Kelly

@

sunindia‌

[sunny_talwar]

Finally the post is published

Will be looking at it sometime today

[Kushal_Chawda]

Can you post the excel file?

[#4]

I setup the excel file in CrossTab to match ALL of the other files.  Hopefully, to simplify.

Thank you!  Kelly

[Kushal_Chawda]

You can do transpose transformation

Data:
LOAD floor(Year) as Year,
Month,
Status,
floor(Amount) as Amount
FROM
[Test.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Transpose()
));

[sunny_talwar]

Check out the attached.