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.
Please help me with this asap
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.
How to remove the space value(3,5,8) from that column ?