Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chiso_chiso
Creator
Creator

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
settu_periasamy
Master III
Master III

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
Creator
Creator
Author

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.

settu_periasamy
Master III
Master III

Hi,

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

chiso_chiso
Creator
Creator
Author

Crosstable Error2.PNG

Find the new error.

settu_periasamy
Master III
Master III

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
Creator
Creator
Author

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

settu_periasamy
Master III
Master III

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