Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
skkrishna
New 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

Re: Many blank or white spaces in Column qlikview

May be this

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

View solution in original post

4 Replies
Highlighted

Re: Many blank or white spaces in Column qlikview

May be this

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

View solution in original post

Highlighted
hdbucher
New Contributor III

Re: Many blank or white spaces in Column qlikview

Example:

LOAD * Inline [

Recorded

A

B

C

D

E];

Concatenate

LOAD * Inline [

Recorded

''];

Highlighted
sasiparupudi1
Honored Contributor III

Re: Many blank or white spaces in Column qlikview

Could you provide a sample to look into the issue?

Highlighted
ravikumar_iyana
Contributor

Re: Many blank or white spaces in Column qlikview

you can provide sample data