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: 
Sai_Mohan
Contributor III
Contributor III

How to remove space in column in qlik sense

Hi Team,

I am new to Qlik Sense. I have a field named 'Ref number' . In that field, there are few values , in which "Space" is also one of the value. I have to remove that space and i need to show values(only numbers) in it .

Note:  I have also unchecked that include null values.

For example:

  • currently it is giving values like: '12', '13','14', '15', '  ', '12', '  ', '  ' , '123' ... Please consider those values like each row has one of the value.

Please help me with this asap

Thanks.

 

Labels (1)
2 Solutions

Accepted Solutions
jwjackso
Specialist III
Specialist III

A simple method in the data load script:

Data:
load *
where Len(Trim(Value)) > 0;
load * Inline [
Value
'12'
'13'
'14'
'15'
' '
'12'
' '
' '
'123'
];

 

View solution in original post

tresesco
MVP
MVP

Try like:

Load  *  from  <>  Where Len(Trim(Ref_num))>0

View solution in original post

4 Replies
jwjackso
Specialist III
Specialist III

A simple method in the data load script:

Data:
load *
where Len(Trim(Value)) > 0;
load * Inline [
Value
'12'
'13'
'14'
'15'
' '
'12'
' '
' '
'123'
];

 

Sai_Mohan
Contributor III
Contributor III
Author

Thanks For Replying!

But in my scenario, I am having those values in a table, which is a excel file.

For example: In a table, my column name is ref_num and values in that is number and space. 

If there is null values i can remove it easily, but it is like space. 

Id Ref_num
15443
25464
3 
45464
5 
64566
73435
8 
96555
104344

How to remove the space value(3,5,8) from that column ?

 

Thanks 

tresesco
MVP
MVP

Try like:

Load  *  from  <>  Where Len(Trim(Ref_num))>0

Sai_Mohan
Contributor III
Contributor III
Author

Thanks!!

It is working.