Discussion Board for collaboration on QlikView Scripting.
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..
I have the following changes but getting the attached errors'
// 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.
load * inline [
// Put the field names of your column dimensions in the VDims table
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 ?