Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Please help me with this asap
Thanks.
A simple method in the data load script:
Data:
load *
where Len(Trim(Value)) > 0;
load * Inline [
Value
'12'
'13'
'14'
'15'
' '
'12'
' '
' '
'123'
];
A simple method in the data load script:
Data:
load *
where Len(Trim(Value)) > 0;
load * Inline [
Value
'12'
'13'
'14'
'15'
' '
'12'
' '
' '
'123'
];
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 |
1 | 5443 |
2 | 5464 |
3 | |
4 | 5464 |
5 | |
6 | 4566 |
7 | 3435 |
8 | |
9 | 6555 |
10 | 4344 |
How to remove the space value(3,5,8) from that column ?
Thanks
Try like:
Load * from <> Where Len(Trim(Ref_num))>0;
Thanks!!
It is working.