Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this expression
=Concat(DISTINCT field,',')
Regards
Anand
Thank you for your help, it worked, but I needed each value separate, so I did it with the load(distinct(Field))