Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading data in Excel

If have a simple load statement

LOAD

    Nationaliteit,

    Soort,

    Bouwjaar,

    jaar,

    aantal

FROM [lib://SWOV_XLS (qlik_kars)/VrachtL.xlsx]

(ooxml, embedded labels, table is Data);

Column Soort contains the following value

Vrachtauto gewicht volle wagen >= 20 t

In the app only "= 20 t" is displayed

How do I load the full text?

I tried

    text(Soort) as Soort,

but that doesn't help

4 Replies
m_woolf
Master II
Master II

try apostrophes around 20 t

mjtaft2017
Partner - Creator
Partner - Creator

What release of QlikSense are you using?  I am using the June 2017 desktop release and I am getting the entire field when I bring in an excel with what you put for your data field (see attached).  Does your field perhaps have an embedded non-visible ascii character that might be splitting the field in 2?

Here is my load statement

LOAD

    Soort

FROM [lib://Excel/Test_data.xlsx]

(ooxml, embedded labels, table is Sheet1);

Anonymous
Not applicable
Author

I'm using 3.2.3, the web version

If I replace ">=" by "gt" in Excel then the whole string is read correctly

If I change "gt" by ">=" in Excel then the whole string is read correctly

This sheet is an Excel created by SAS.

I generated it anew, got the =20 t again

Open the Excel and set the column Soort to type Text

Now the whole string is read correctly!

Thanks for your help

sonkumamon
Creator
Creator

When defining the table separator and language, try changing the Quoting from MSQ to None, maybe it will help.