Discussion board where members can get started with QlikView.
Can anyone please help me on this.
From the concatenate expression output need to delete the pink color records
=[Cov Group]&' '&[Cap Group]
'Solutions & Digital'
Please let me know how to proceed.
Thanks in advance.
After concatenation load another table and filter this rows
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
Not entirely sure I understand, do you have a sample to elaborate?