Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chiso_chiso
New Contributor III

Loading Estimates/Budget Data

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

7 Replies

Re: Loading Estimates/Budget Data

You can try with this..  multi_header_pivot_import.qvw

Just you need to change the below colored ones..

Capture.JPG

Sample Attached

chiso_chiso
New Contributor III

Re: Loading Estimates/Budget Data

Crosstable Error1.PNGThanks 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.

Re: Loading Estimates/Budget Data

Hi,

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

chiso_chiso
New Contributor III

Re: Loading Estimates/Budget Data

Crosstable Error2.PNG

Find the new error.

Re: Loading Estimates/Budget Data

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
New Contributor III

Re: Loading Estimates/Budget Data

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

Re: Loading Estimates/Budget Data

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

Community Browser