topic Re: Spacing in QlikView

Spacing

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

Hi All,

I have fetched the data from Oracle DB and converted into QVD .

I have field called Dept when i load the data , I see 2 two TSTS as shown in the screenshot below .

One is with space and the other is witout space . How do i make it as one entry .

Thanks in Avdnace

smilingjohn — Wed, 07 Oct 2020 18:57:03 GMT

Hi Communtiy,

Any help on this ?

QFabian — Wed, 07 Oct 2020 19:10:44 GMT

hi!, trying to use this in your script :

trim(Dept) as Dept ,

smilingjohn — Wed, 07 Oct 2020 19:13:44 GMT

Trim dont work still it shows double values

QFabian — Wed, 07 Oct 2020 19:17:26 GMT

where is showing the unexpected value?, a filter?

smilingjohn — Wed, 07 Oct 2020 19:23:26 GMT

thhis showing in list box as well as in the table and charts . it is shwoing 2 values one with sapce and and with no space

smilingjohn — Thu, 08 Oct 2020 03:29:08 GMT

Hi All

Can't we remove the double entry

FakeJupiter — Thu, 08 Oct 2020 10:19:49 GMT

Hi.

Tell me more about the field.

Are all values supposed to be 4 letters long?

If so, try this in script:

left(Dept, 4) as Dept

If that doesn't help, you can try:

keepchar (Dept,'abcdefghijklmnopqrstuvwxyz' ) as Dept

smilingjohn — Thu, 08 Oct 2020 12:39:36 GMT

No , there are of different length and many .

I want it to appear it as single values , I tried with trim function but still no effect . the output shows 2 values with space .

FakeJupiter — Thu, 08 Oct 2020 13:52:55 GMT

Did the keepchar function I posted before work?