topic Re: Space inside filed data disappear after loading in QlikView

Space inside filed data disappear after loading

Vince_CH — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Space inside filed data disappear after loading

B_Waidhofer — Thu, 29 Nov 2018 09:49:40 GMT

hi there,

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

activate "Override Document Settings"

and click on "number"

Best greats

the newbee

Re: Space inside filed data disappear after loading

Anil_Babu_Samineni — Thu, 29 Nov 2018 09:53:42 GMT

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

Re: Space inside filed data disappear after loading

Vince_CH — Thu, 29 Nov 2018 10:39:57 GMT

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

Re: Space inside filed data disappear after loading

Vince_CH — Thu, 29 Nov 2018 10:41:45 GMT

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.

Re: Space inside filed data disappear after loading

Vince_CH — Thu, 29 Nov 2018 10:48:53 GMT

please refer to attached file after loading...

Re: Space inside filed data disappear after loading

Vince_CH — Sat, 01 Dec 2018 16:42:33 GMT

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!

Re: Space inside filed data disappear after loading

Anil_Babu_Samineni — Sun, 02 Dec 2018 06:52:57 GMT

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

Re: Space inside filed data disappear after loading

Vince_CH — Sun, 02 Dec 2018 14:30:25 GMT

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!