Loading Estimates/Budget Data

[chiso_chiso]

Gurus,

Kindly assist in loading the attached budget data. I have done a cross table before but this is a bit extra.

Attached is the sample data.

Thank you in advance

[settu_periasamy]

You can try with this..  multi_header_pivot_import.qvw

Just you need to change the below colored ones..

Sample Attached

[chiso_chiso]

Thanks settu_periasamy‌

I have the following changes but getting the attached errors'

SET vSourceFile =  'Test.xls';	//  'pivotimporttest2.xlsx'
SET vSheet = '[Sheet1]';					//  '[Sheet1]'
SET vType = 'biff';							//  'ooxml'

//  Put the field names of your horizontal dimensions in the HDims table

//  NOTE: Qlikview is case-sensitive, so make sure you don't forget any capitals

//  in your field names.

HDims:

load * inline [

HDimLevel, HFieldName

HDim1, Year

HDim2, Month

HDim3, Qty

HDim4, Turnover

];

//  Put the field names of your column dimensions in the VDims table

//  NOTE: Qlikview is case-sensitive, so make sure you don't forget any capitals

//  in your field names.

VDims:

load * inline [

VFieldName

Category

Colour

Budget Version

];

Kindly help.

[settu_periasamy]

Hi,

Can you check with attached excel file? qvw and excel file should be in same directory..

[chiso_chiso]

Find the new error.

[settu_periasamy]

i posted as a 'Xlsx' file, but it shows 'xls' file. if it is 'Xlsx' file then we need to change the type as 'ooxml'

Have you tried with i posted qvw..

It should be like..

SET vSourceFile =  'Test.xlsx';     

SET vSheet = '[Sheet1]';                      
SET vType = 'ooxml';                                     


HDims:
load * inline [
HDimLevel, HFieldName
HDim1, Year
HDim2, Month
HDim3, Data
];


VDims:
load * inline [
VFieldName
Category
Colour
Budget Version
];

[chiso_chiso]

Awesome! I am sorted now.. Thanks very much settu_periasamy‌

[settu_periasamy]

No problem. Can you close this thread if you got the answer ?