2 Replies Latest reply: Nov 26, 2014 1:33 PM by Ira G RSS

    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