Space inside filed data disappear after loading

[Vince_CH]

Hi All, i tried to load from excel a list of material number with space inside the value, like below, after i loaded it into qlikview, the space disappear, how to keep the original filed data as it is?  thanks for help

[B_Waidhofer]

hi there,

just right click on the table in QlickView -> Properties -> Number 

activate "Override Document Settings"

and click on "number"

Best greats

the newbee 

[Anil_Babu_Samineni]

Please post sample application

Note - Qlik removes the space while loading. To required, We may use Text else we may look once you share any sample

[Vince_CH]

hi, it is not working , as the numbers could be in different types.

[Vince_CH]

okay, please find the source file as attached in excel, if you load it by qlikview, you will see the space inside data disappear.

thanks for help.

[Vince_CH]

please refer to attached file after loading...

[Vince_CH · Accepted solution]

i have resolved this issue as following;
in the script, load as below:
text([Material Number]) as [Material Number],
it works after loading and the space is still there.
however, thanks to all anyway. nice weekend!

[Anil_Babu_Samineni]

I suggested the same, why your reply as solution and not mine?

[Vince_CH]

Hi, there might be some gap between our understanding, you guessed "To required, We may use Text else we may look once you share any sample", but didn't give a follow up advice how exactly after my loading sample. i looked at other posts earlier also tried with some others means to get it. anyway, do thanks for interaction here, and i have still have other open posts in the community, and will definitely honor your solution if you can support. thanks!