Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
skkrishna
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
sunny_talwar

May be this

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

View solution in original post

4 Replies
sunny_talwar

May be this

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

View solution in original post

hdbucher
Contributor III
Contributor III

Example:

LOAD * Inline [

Recorded

A

B

C

D

E];

Concatenate

LOAD * Inline [

Recorded

''];

sasiparupudi1
Master III
Master III

Could you provide a sample to look into the issue?

ravikumar_iyana
Creator
Creator

you can provide sample data