Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

divianjani
New Contributor II

How Load Excel Columns Headers without first blank rows

Hi Everyone, Hope you all doing great !!!!

I need small help. I have one source data file like showing  in below screenshot. how to load this kind of data from the excel files into QlikVew/Qlik Sense. I want to load only Sales Person Name, Product and Sales Amount columns.
can any one help me. 

Thanks in Advance 🙂

Need to Load only Data columns.png

 


 

 

1 Solution

Accepted Solutions
Partner
Partner

Re: How Load Excel Columns Headers without first blank rows

While inserting the data in script editor give Header size as 3 Lines and give embedded labels. it should work fine.

You Know What To Do.
1 Reply
Partner
Partner

Re: How Load Excel Columns Headers without first blank rows

While inserting the data in script editor give Header size as 3 Lines and give embedded labels. it should work fine.

You Know What To Do.