Discussion board where members can get started with QlikView.
I have a column name RECORDED
which is a free text column
When i had loaded it in qlikview
I saw many white spaces or blanks in List box
It has five white spaces or blanks and then data
One blank and remaining data
I need only one blank and remaining data in that column
Thanks in advance.
May be this
If(Len(Trim(RECORDED)) = 0, ' ', RECORDED) as RECORDED
View solution in original post
LOAD * Inline [
Could you provide a sample to look into the issue?
you can provide sample data