Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data source have differnt ailment

Dear all

i am loading data  from qvd  to  qlikview

my one filed   XYZ

                     100

                     200

                     300

         400

         500

         600

                    700

                     800

                    900

i need   XYZ

           100

           200

           300

            400

            500

            600

            700

            800

7 Replies
jfkinspari
Partner - Specialist
Partner - Specialist

Hi surik147,

If's because there are leading spaces in the field, you can use the TRIM functions to remoce them.

=ltrim(XYZ)

khadeer
Specialist
Specialist

Hi,

Num(LTrim(XYZ)) as XYZ; If u have all Numbers.

Regards,

Khadeer

Not applicable
Author

thank for uer reply

i  am getting like  th is if i use

  100

  200

  300

  400

             500

             600

             700

Not applicable
Author

thank for uer reply

i  am getting like  th is if i use

  100

  200

  300

  400

             500

             600

             700

SunilChauhan
Champion
Champion

use

Num(trim(XYZ))

Hope this helps

Sunil Chauhan
Not applicable
Author

thank for uer  reply

xyz  like  300,33H,123

MayilVahanan

hi

try like this

trim(subfield(xyz,','))

hpe it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.