topic Re: Get comma separated values of a field in QlikView

Get comma separated values of a field

rajat2392 — Thu, 07 Apr 2016 08:43:53 GMT

Hi,

I have a field with number values. There are around 106,000 records in the table.

I want all the values in any object as comma separated.

Can anybody suggest me how to achieve it.

Thanks

Rajat Arora

Re: Get comma separated values of a field

kaushiknsolanki — Thu, 07 Apr 2016 08:44:55 GMT

Try this.

Concat(FieldName,',')

Regards,

Kaushik Solanki

Re: Get comma separated values of a field

Chanty4u — Thu, 07 Apr 2016 08:46:32 GMT

am not sure...

u can give coma for decimal and thousand..... it wil seperate comma.

Re: Get comma separated values of a field

rajat2392 — Thu, 07 Apr 2016 08:48:07 GMT

It doesn't work for 100,000 records in my case.

Re: Get comma separated values of a field

Chanty4u — Thu, 07 Apr 2016 08:48:39 GMT

yes it is working for all..

go to document properties > select nymber tab-->select ur Number fileds--->change to override---> follow above image

Re: Get comma separated values of a field

rajat2392 — Thu, 07 Apr 2016 08:50:29 GMT

Hi,

I need the distinct values in the field together with a comma separator.

This is not my requirement actually.

Thanks for the reply.

Re: Get comma separated values of a field

kaushiknsolanki — Thu, 07 Apr 2016 08:55:06 GMT

For a distinct value you can out distinct keyword.

Concat(Distinct FieldName,',')

Regards,

Kaushik Solanki

Re: Get comma separated values of a field

kkkumar82 — Thu, 07 Apr 2016 08:56:42 GMT

Like this may be

Concat(Distinct fieldName,',')

Are you using this in text box or where?

Thanks

Kiran Kumar

Re: Get comma separated values of a field

Chanty4u — Thu, 07 Apr 2016 08:57:57 GMT

as mentioned Kaushik use distinct function=

=Concat(Distinct Filedname,',')

Re: Get comma separated values of a field

rajat2392 — Thu, 07 Apr 2016 08:59:00 GMT

I have total 106,081 distinct values.

I want all of them to come in a row with comma separation.

It doesn't happen as the records are huge.

Is there any other way?

Thanks

Rajat Arora

Re: Get comma separated values of a field

Kushal_Chawda — Thu, 07 Apr 2016 08:59:38 GMT

Want to do it in script or on front end? what is the expected output you need?

Re: Get comma separated values of a field

rajat2392 — Thu, 07 Apr 2016 09:02:16 GMT

Text object is required.

I can manage in a straight table as well.

But this expression doesn't work with this huge set of record.

Re: Get comma separated values of a field

rajat2392 — Thu, 07 Apr 2016 09:04:32 GMT

Script is also fine.

Need all the distinct values in a row with comma separation.

Re: Get comma separated values of a field

kaushiknsolanki — Thu, 07 Apr 2016 09:04:44 GMT

What you can do is use the concat function in script and then use that in chart or text box.

Regards,

Kaushik Solanki

Re: Get comma separated values of a field

Kushal_Chawda — Thu, 07 Apr 2016 09:12:31 GMT

Data:

LOAD FieldA,

FieldB,

Concat(distinct FieldC,',') as CommaSep

FROM table

group by FieldA,FieldB;

Re: Get comma separated values of a field

Kushal_Chawda — Thu, 07 Apr 2016 09:24:56 GMT

what is the purpose of showing huge value in same row..?

Re: Get comma separated values of a field

rajat2392 — Thu, 07 Apr 2016 10:14:00 GMT

Thanks Kushal

This solved my issue.

Thanks to everyone else for the responses.