Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Selecting the header

Hi.

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
sushil353
Honored Contributor II

Re: Selecting the header

hi,

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

HTH

sushil

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:

Embedded_Labels.jpg

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 :

Labels.png

Thanks,

Madhu

Not applicable

Re: Selecting the header

Did you test this ?

Community Browser