Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Excel Loading issue

While loading columns from excel it is taking first half only like below. Is there any way we can handle in QV as We have many columns in data.

Excel have like below:Excel Screen.JPG

QVW is loading  like below:QVW Screen.JPG

1 Reply
marcus_sommer

I think if you enables multi-lines within your rows, headers and titles you will see the whole fieldvalue. An alternatively could be to remove this linebreak within the load or in the UI, maybe with something like:

...
replace(Field, chr(10), chr(32)) as Field
...

- Marcus