topic Re: Get all field values in QlikView https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627102#M543837 <HTML><HEAD></HEAD><BODY><P>You can use the expression concat( {1} distinct <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ProductNr ', ') in combination with a straigth or pivot table (chart object)</SPAN></P></BODY></HTML> Thu, 08 May 2014 15:28:26 GMT 2014-05-08T15:28:26Z Get all field values https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627101#M543836 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to concatenate all field values inside a straight table, disregarding the selections made in this field. </P><P></P><P>Example:</P><P></P><P>Category&nbsp;&nbsp;&nbsp;&nbsp; ProductNr</P><P>-------------&nbsp;&nbsp;&nbsp;&nbsp; ---------------</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P></P><P>A selection is made in field ProductNr, Value 1. </P><P>The straight table with dimension Category and concatenation over ProductNr. displays:</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P>But what I need is every value given for the selected ProductNr. and the associated Category:</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,2</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,4</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,5,6</P><P></P><P>Are there any possibilities via set analysis? I have tried some, but nothing worked...</P><P></P><P>Thanks in advance!</P></BODY></HTML> Thu, 08 May 2014 15:18:30 GMT https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627101#M543836 2014-05-08T15:18:30Z Re: Get all field values https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627102#M543837 <HTML><HEAD></HEAD><BODY><P>You can use the expression concat( {1} distinct <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ProductNr ', ') in combination with a straigth or pivot table (chart object)</SPAN></P></BODY></HTML> Thu, 08 May 2014 15:28:26 GMT https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627102#M543837 2014-05-08T15:28:26Z Re: Get all field values https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627103#M543838 <HTML><HEAD></HEAD><BODY><P>Please take a look at the example attached.</P></BODY></HTML> Thu, 08 May 2014 15:36:27 GMT https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627103#M543838 sudeepkm 2014-05-08T15:36:27Z Re: Get all field values https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627104#M543839 <HTML><HEAD></HEAD><BODY><P>Will this work for you?</P><P>-Greg</P></BODY></HTML> Thu, 08 May 2014 15:50:44 GMT https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627104#M543839 Greg_Williams 2014-05-08T15:50:44Z Re: Get all field values https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627105#M543840 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>thank you all for your replies!</P><P></P><P>The challenge for me is to show only the values of Category associated with the selection in ProductNr., so when making the selection ProductNr "1", Category D should not be shown inside the straight table...</P><P></P><P>Any further hints?</P></BODY></HTML> Fri, 09 May 2014 07:39:18 GMT https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627105#M543840 2014-05-09T07:39:18Z Re: Re: Get all field values https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627106#M543841 <HTML><HEAD></HEAD><BODY><P>Expression: =concat( {1&lt;Category=p({&lt;ProductNr=p(ProductNr)&gt;}Category)&gt;} distinct ProductNr ,', ')</P><P></P><P></P><P>See attachment</P></BODY></HTML> Fri, 09 May 2014 07:47:29 GMT https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627106#M543841 tresB 2014-05-09T07:47:29Z Re: Re: Get all field values https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627107#M543842 <HTML><HEAD></HEAD><BODY><P>Try this</P></BODY></HTML> Fri, 09 May 2014 08:08:27 GMT https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627107#M543842 anbu1984 2014-05-09T08:08:27Z Re: Get all field values https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627108#M543843 <HTML><HEAD></HEAD><BODY><P>Thank you - this is it <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 09 May 2014 08:21:35 GMT https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627108#M543843 2014-05-09T08:21:35Z Re: Get all field values https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627109#M543844 <HTML><HEAD></HEAD><BODY><P>Would work, but would require additional effort inside the datamodel - thank you anyway!</P></BODY></HTML> Fri, 09 May 2014 08:24:37 GMT https://community.qlik.com/t5/QlikView/Get-all-field-values/m-p/627109#M543844 2014-05-09T08:24:37Z