topic Loading Estimates/Budget Data in QlikView

Loading Estimates/Budget Data

chiso_chiso — Wed, 20 Apr 2016 03:23:57 GMT

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

Re: Loading Estimates/Budget Data

settu_periasamy — Wed, 20 Apr 2016 04:44:00 GMT

You can try with this.. multi_header_pivot_import.qvw

Just you need to change the below colored ones..

Sample Attached

Re: Loading Estimates/Budget Data

chiso_chiso — Wed, 20 Apr 2016 08:07:33 GMT

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

Re: Loading Estimates/Budget Data

settu_periasamy — Wed, 20 Apr 2016 09:29:38 GMT

Hi,

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

Re: Loading Estimates/Budget Data

chiso_chiso — Wed, 20 Apr 2016 09:52:31 GMT

Find the new error.

Re: Loading Estimates/Budget Data

settu_periasamy — Wed, 20 Apr 2016 10:00:08 GMT

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
];

Re: Loading Estimates/Budget Data

chiso_chiso — Wed, 20 Apr 2016 10:12:19 GMT

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

Re: Loading Estimates/Budget Data

settu_periasamy — Wed, 20 Apr 2016 10:20:02 GMT

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