Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bhavvibudagam
Contributor II

concatenate expression

Hi Experts,

Can anyone please help me on this.

From the concatenate expression output need to delete the pink color records

Concatenate expression:

=[Cov Group]&' '&[Cap Group]

output

Corps

FS

Audit

KBS

'Solutions & Digital'

Corps Audit

Please let me know how to proceed.

Thanks in advance.

1 Solution

Accepted Solutions

Re: concatenate expression

After concatenation load another table and filter this rows

Ex:-

Load

*

Resident TableName

Where Not Match([Cov Group]&' '&[Cap Group],'Corps','FS,Audit','TPL','Consulting','Deal Adviosory');


Drop Table TableName;


But it better you can create any flag field on the table and then use that flag to filter those rows, May be good idea.

View solution in original post

2 Replies

Re: concatenate expression

Not entirely sure I understand, do you have a sample to elaborate?

Re: concatenate expression

After concatenation load another table and filter this rows

Ex:-

Load

*

Resident TableName

Where Not Match([Cov Group]&' '&[Cap Group],'Corps','FS,Audit','TPL','Consulting','Deal Adviosory');


Drop Table TableName;


But it better you can create any flag field on the table and then use that flag to filter those rows, May be good idea.

View solution in original post