topic Re: concatenate expression in QlikView

concatenate expression

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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

Audit

KBS

'Solutions & Digital'

Corps Audit

Please let me know how to proceed.

Thanks in advance.

sunny_talwar — Tue, 05 Dec 2017 14:02:34 GMT

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

its_anandrjs — Tue, 05 Dec 2017 14:07:53 GMT

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.