topic How to manage an excel file in QlikView

How to manage an excel file

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 26 Jun 2017 09:18:48 GMT

Please share some sample data.

MK_QSL — Mon, 26 Jun 2017 09:23:56 GMT

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 — Mon, 26 Jun 2017 10:47:24 GMT

Here some example of data.

Thank you for the support