importing pivot format excel in qv

Wed, 25 Nov 2020 16:16:04 GMT

Hi , i am new in qv. i have one issue when i am importing pivot formated excel in qv. After importing excel if i select category AA and Subcategory c then it showing only Apr'14,Aug'14and Oct'14 and H1 2014-15 and Q2 14-15 data but others are not showing. and values are showing wrong. Please help . a sample data i am using this script:

// If I did things correctly the only thing you have to do is enter the field names

// of your horizontal and vertical dimensions in the tables HDims and VDims in

// the correct order and set the variables vSourceFile, vSheet and vType to the

// correct values for your source excel file.

SET vSourceFile = 'Book12.xlsx'; // 'pivotimporttest2.xlsx'

SET vSheet = '[Sheet1]'; // '[Sheet1]'

SET vType = 'ooxml'; // '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, Account

HDim2, Acc1

HDim3, Year

HDim4, MonthYear

];

// 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: importing pivot format excel in qv

Mon, 03 Oct 2016 17:19:51 GMT

gwassenaar‌ stephen-x.redmond‌sunny‌ please help

Re: importing pivot format excel in qv

Mon, 03 Oct 2016 17:27:33 GMT

stalwar1‌cleveranjos‌jagan‌ please help to solve my problem

topic Re: importing pivot format excel in qv in QlikView

importing pivot format excel in qv

Re: importing pivot format excel in qv

Re: importing pivot format excel in qv