Data Source Headers Not An Option

Fri, 20 Jul 2012 13:02:49 GMT

I am using a tab of a spreadsheet as a data source. Many of the fields on it were created by macros that brought fields over from another tab and from formulas. It has clearly defined Header names on the first row. When I select this spreadsheet as a data source, the next option is to select the data representation of the headers. My only option is to rename the headers and not use the headers already defined in the spreadsheet even though they appear in the display box of that step. After going through the setup process and attempting to create a pivot table, I still do not have the option of using the already defined headers.

Does anyone know why this is happening and know anyone of correcting this?

Thanks

Re: Data Source Headers Not An Option

Fri, 20 Jul 2012 13:11:45 GMT

you can only use column names when they are expressions like: [ Column1 ]

domensions got the same names like after loding script (you changed only label)

topic Data Source Headers Not An Option in QlikView

Data Source Headers Not An Option

Re: Data Source Headers Not An Option