Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

distinct information

Hi everybody,

as you can see I am new to QlikView and hope that you can help me, I propose that the solution is easy, but still...

I have a Field that contains, for example, these data:

1

1

1

2

2

3

3

3

I want to write distinct elements of this Field in a text document, till now I have this:

textcount(distinct(field)) = 3, I assume that these are: '1,2,3'. How can I get the values? and not the quantity of distinct elements?

Looking forward for your answer

1 Solution

Accepted Solutions

Re: distinct information

Hi,

Try this expression

=Concat(DISTINCT field,',')

concat.png

Regards

Anand

2 Replies

Re: distinct information

Hi,

Try this expression

=Concat(DISTINCT field,',')

concat.png

Regards

Anand

Not applicable

Re: distinct information

Thank you for your help, it worked, but I needed each value separate, so I did it with the load(distinct(Field))

Community Browser