Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try with this.. multi_header_pivot_import.qvw
Just you need to change the below colored ones..
Sample Attached
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.
Hi,
Can you check with attached excel file? qvw and excel file should be in same directory..
Find the new error.
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
];
Awesome! I am sorted now.. Thanks very much settu_periasamy
No problem. Can you close this thread if you got the answer ?