topic Re: Field values in 1 line in QlikView

Field values in 1 line

Tue, 14 Apr 2015 13:55:52 GMT

Hi All,

i have data like this in straight table:

product	sub-product
A	apple
A	banana
B	book
B	pen

i want like this :

product	sub-product
A	apple,banana
B	book,pen

how to do this,the sub-product should be in 1 line based on product with , seperator.

thanks in advance

Re: Field values in 1 line

chriscammers — Tue, 14 Apr 2015 14:00:28 GMT

Product would be your dimension and then you would create an expression for the sub-product field using the concat function. concat creates a delimited list of the values in a field.

Concat(Distinct sub-product,',')

I hope this helps.

Chris

Re: Field values in 1 line

awhitfield — Tue, 14 Apr 2015 14:06:18 GMT

Hi there

Use the following

=Concat(sub-product,',')

Regards

Andy