Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Selecting the header


When i pull an excel report in qlikview, in the second step its giving me 2 options.

1. use column headers

2. add column headers.

i have the headers already in the excel file. so in this scenario i will need to select option 1.

But its not allowing me to select option 1.

May i k now y this happening ?

Thank you.

5 Replies
Honored Contributor II

Re: Selecting the header


Try to use embedded label's while extracting the xl file.



Not applicable

Re: Selecting the header

hi sushil,

i have no idea on that.

i have an xl file whit raw data, and i ahve defined headers too.

But i couldnt select the option. Can you guide me on the same.

Thank you.

Not applicable

Re: Selecting the header

You ought to enter command manually in the script editor. Have you tried this?

Here's an example, specify correctly the lables name, hope this could help you:


Not applicable

Re: Selecting the header

When you select an excel report to load in qlikview, you could use the Embedded labels in interface too as shown below :




Not applicable

Re: Selecting the header

Did you test this ?

Community Browser