Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Selecting second row as headers from excel import

Hi everyone,

I have a table in an excel spreadsheet and the first row is just a merged cell with the table title. The headers are in the second row.

As I have read in one of Qlik Sense materials, it is recommended importing tables from excel with headers in the first row.

What would be the easiest way solve this?

Thanks in advance.

1 Solution

Accepted Solutions
PabloTrevisan
Partner - Creator II
Partner - Creator II

Hi Rhenan,

my qliksense is in portuguese, but the important thing is that you can define in which line the header will be in this print box

embeded.jpg

It help's you ? Tell me please.

View solution in original post

2 Replies
PabloTrevisan
Partner - Creator II
Partner - Creator II

Hi Rhenan,

my qliksense is in portuguese, but the important thing is that you can define in which line the header will be in this print box

embeded.jpg

It help's you ? Tell me please.

Anonymous
Not applicable
Author

Great, Pablo!

I just had to set Tamanho do cabeçalho to 1. It was right in my face and I didn't see it!

Thanks a lot.