How to manage an excel file

[qlikviewaf]

Hi Guys,

i have to load the budget which is in different files 2016.xls  2017.xls based on the year.

I have to link my budget using the Name (which is fine in the excel) and the period/year.

As you can see the column name are "2017/Jan" , "2017/Feb"

How i can use this information to be linked to my calendar with Name , Month and Year?

Thank you, any help is really appreciated.

[prma7799]

Please share some sample data.

[MK_QSL]

Something like below. Change field names accordingly.

CrossTable(YearMonth, Sales)

Data:

Load * Inline

[

  Name, 2016/Jan, 2016/Feb, 2016/Mar, 2017/Jan, 2017/Feb, 2017/Mar

  A, 100, 110,120,130,140,150

  B, 200, 210,220,230,240,250

  C, 300, 310,320,330,340,350

];

MasterCalendar:

Load YearMonth, Month(YearMonth1) as Month, Year(YearMonth1) as Year;

Load Distinct YearMonth, Date#(YearMonth,'YYYY/MMM') as YearMonth1 Resident  Data;

[qlikviewaf]

Here some example of data.

Thank you for the support