Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

javedsheikh
New Contributor

QlikSense : Auto trimming of spaces between text field ( Oracle DB)

Hi All,

I am working in qlik sense and encounter a weird problem. Details below

The data coming from DB is like

test:

Load *inline

[text

6611

66      11

1166

];

Output in Qlik Sense

6611

1166

Qlik Sense somehow removed the spaces between the data. Just wanted to know why

Your valuable help or any previous experience with similar issue will be greatly appreciated.

Thanks,

Javed

4 Replies
devarasu07
Honored Contributor II

Re: QlikSense : Auto trimming of spaces between text field ( Oracle DB)

Hi Javed,

Because it's number field, by default while load these data it will remove the space from that number field. to prevent u can use Text function.

test:

Load text(text) as text_Revised inline [

text

6611

66      11

1166

];

Capture.JPG

Hope this helps to you

Thanks,

Deva

javedsheikh
New Contributor

Re: QlikSense : Auto trimming of spaces between text field ( Oracle DB)

Thanks Devarasu!! This is Char field in Database.  I have tried another scenario

test:

Load *inline

[text

6611

66      11

1166

2  3333 22   11

];

Output is below

Capture.PNG

It is not removing space by default. If you have a duplicate then this weird thing happen.. Please correct me if I have wrong assumption.

devarasu07
Honored Contributor II

Re: QlikSense : Auto trimming of spaces between text field ( Oracle DB)

Hi,

yes. qlikview/sense will return  distinct unique vale in chart object (prompt, table, chart etc) because it's number. first it will auto trim and then it will show the distinct value in your chart object.

P.S: if you wish to retain the same string in qlik then u have to use the text / keepchar / other string function.

hope it's clear, close this thread by marking as helpful and correct.

Regards,

Deva

luismadriz
Valued Contributor

Re: QlikSense : Auto trimming of spaces between text field ( Oracle DB)

Thanks for sharing this Javed, I never noticed it.

I ran other tests coming from an excel file as well and this is the conclusion I'm getting:

It seems to depend on the load order: whatever you load first, then the rest that's similar will follow the "template" provide by the first... and it seems to work both ways from number to text and from text to number

First 11 22 and then 1122 will produce 2 records with 11 22

First 1 2 3 4 5 6 and then 123456 will produce 2 records with 1 2 3 4 5 6

First 1122 and then 1 1 2 2 will produce 2 records with 1122

First 123456 and then 123 4               56 will produce 2 records with 123456

Even coming from different loads, one from an inline for example and the second load from an excel file for the same qlik sense table.

Spooky!!!

I tried to find any information about on the Help but couldn't. I hope other community members would see this and share their thoughts

Thanks again Javed,

Cheers

Luis

Community Browser