topic Re: Field Concatenation in QlikView

Field Concatenation

brindlogcool — Fri, 07 Jun 2013 05:39:17 GMT

I want to concatenate district and product columns like this District (P1,P2,P3). District,P1,P2,P3 are individual columns.

The problem here is always not all the P1,P2,P3 will not have values . So there can be scenarios as below

District --- No product so it should display District

District ,P1 is NULL, P2,P3 --- District (P2,P3)

I tried to concatenate it is coming with blanks as District (,P2,P3)

I tried to loop through and create tables but it is creating multiple tables and not working

Re: Field Concatenation

Gysbert_Wassenaar — Fri, 07 Jun 2013 07:52:55 GMT

Try: District & replace(replace(replace( '(' & alt(dual(P1,1), '#') & ',' & alt(dual(P2,1), '#') & ',' & alt(dual(P2,1), '#') & ')' , ',#', ''), '#,', ''),'()','')

Re: Field Concatenation

brindlogcool — Fri, 07 Jun 2013 14:29:28 GMT

Perfect solution.... Thank you so much