distinct information

[#1]

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

[its_anandrjs · Accepted solution]

Hi,

Try this expression

=Concat(DISTINCT field,',')

Regards

Anand

[#3]

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