Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Not all the data from Excel are loaded

Hi,

I am new to Qlikview and am trying to load a flat file into Qlikview. I did CTRL E and in teh data from Files used the Table Files and picked up the appropriate file. The excel file has 350 line items but only around 300 are getting loaded into Qlikview. I have checked that there are no blank rows as well.

Also, the headers are sometimes coming in correctly (Units, revenues, name, product ID etc), but some of them have brackets around them. This is creating issues when I try to do additional calculations...

Any help on this would be very helpful,

thank you,

VV

2 Replies
tresesco
MVP
MVP

Can you upload the excel you are trying with?

Thanks

sujeetsingh
Master III
Master III

Seems surprising behaviour

Can you post a sample