topic distinct information in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/distinct-information/m-p/819126#M2845 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>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... </P><P></P><P>I have a Field that contains, for example, these data: </P><P></P><P>1</P><P>1</P><P>1</P><P>2</P><P>2</P><P>3</P><P>3</P><P>3</P><P></P><P>I want to write distinct elements of this Field in a text document, till now I have this:</P><P></P><P>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?</P><P></P><P>Looking forward for your answer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Tue, 25 Nov 2014 19:52:18 GMT 2014-11-25T19:52:18Z distinct information https://community.qlik.com/t5/Qlik-Learning-Discussions/distinct-information/m-p/819126#M2845 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>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... </P><P></P><P>I have a Field that contains, for example, these data: </P><P></P><P>1</P><P>1</P><P>1</P><P>2</P><P>2</P><P>3</P><P>3</P><P>3</P><P></P><P>I want to write distinct elements of this Field in a text document, till now I have this:</P><P></P><P>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?</P><P></P><P>Looking forward for your answer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Tue, 25 Nov 2014 19:52:18 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/distinct-information/m-p/819126#M2845 2014-11-25T19:52:18Z Re: distinct information https://community.qlik.com/t5/Qlik-Learning-Discussions/distinct-information/m-p/819127#M2846 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this expression</P><P></P><P>=Concat(DISTINCT field,',')</P><P></P><P><IMG alt="concat.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/72106_concat.png" /></P><P>Regards</P><P>Anand</P></BODY></HTML> Tue, 25 Nov 2014 20:05:08 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/distinct-information/m-p/819127#M2846 its_anandrjs 2014-11-25T20:05:08Z Re: distinct information https://community.qlik.com/t5/Qlik-Learning-Discussions/distinct-information/m-p/819128#M2847 <HTML><HEAD></HEAD><BODY><P>Thank you for your help, it worked, but I needed each value separate, so I did it with the load(distinct(Field))</P></BODY></HTML> Wed, 26 Nov 2014 18:33:47 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/distinct-information/m-p/819128#M2847 2014-11-26T18:33:47Z