Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Spacing

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 

1 Solution

Accepted Solutions
Creator
Creator

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

 

 

View solution in original post

9 Replies
Creator III
Creator III

Hi Communtiy,

Any help on this ?

Specialist
Specialist

hi!, trying to use this in your script :

trim(Dept) as Dept ,

QFabian
Creator III
Creator III

Trim dont work still it shows double values

Specialist
Specialist

where is showing the unexpected value?, a filter?

QFabian
Creator III
Creator III

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

Creator III
Creator III

Hi All

Can't we remove the double entry

Creator
Creator

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

 

 

View solution in original post

Creator III
Creator III

Thanks @FakeJupiter  ,

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 .

Creator
Creator

Did the keepchar function I posted before work?