Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Many blank or white spaces in Column qlikview

Hi

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

Example

Recorded

A

B

C

D

E

Present output:

A

B

C

D

E

It has five white spaces or blanks and then data

Required output:

A

B

C

D

E

One blank and remaining data

I need only one blank and remaining data in that column

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted

May be this

If(Len(Trim(RECORDED)) = 0, ' ', RECORDED) as RECORDED

View solution in original post

4 Replies
Highlighted

May be this

If(Len(Trim(RECORDED)) = 0, ' ', RECORDED) as RECORDED

View solution in original post

Highlighted
Contributor III
Contributor III

Example:

LOAD * Inline [

Recorded

A

B

C

D

E];

Concatenate

LOAD * Inline [

Recorded

''];

Highlighted
Master III
Master III

Could you provide a sample to look into the issue?

Highlighted
Creator
Creator

you can provide sample data