topic Re: Distinct in QlikView https://community.qlik.com/t5/QlikView/Distinct/m-p/1457959#M795281 <HTML><HEAD></HEAD><BODY><P>I try this is not working, Qlikview doesn't accept my expression but is worling ..</P><P></P><P>CLI_DISTINCT:<BR /> <SPAN style="color: #0000ff;">noconcatenate</SPAN> <STRONG style="color: #0000ff;">load</STRONG><BR />IDCLIENT,</P><P>YEARpurchase<BR /> <BR /> <SPAN style="color: #0000ff;">resident</SPAN> DOSSIER_1; <BR /> <BR /> <SPAN style="color: #0000ff;">left</SPAN> <SPAN style="color: #0000ff;">join</SPAN> (CLI_DISTINCT)<BR /> <BR />CLI_DISTINCT1:<BR /> <SPAN style="color: #0000ff;">noconcatenate</SPAN> <STRONG style="color: #0000ff;">load</STRONG><BR /> *<BR /> <SPAN style="color: #0000ff;">resident</SPAN> CLI_DISTINCT; <BR /> <BR />CLI_DISTINCT2:<BR /> <SPAN style="color: #0000ff;">noconcatenate</SPAN> <STRONG style="color: #0000ff;">load</STRONG><BR /> <SPAN style="color: #0000ff;">distinct</SPAN>*<BR /> <BR /> <SPAN style="color: #0000ff;">resident</SPAN> CLI_DISTINCT; <BR /> <BR /> <STRONG style="color: #0000ff;">DROP</STRONG> <SPAN style="color: #0000ff;">Tables</SPAN> CLI_DISTINCT; </P></BODY></HTML> Wed, 03 Jan 2018 10:21:45 GMT ab92 2018-01-03T10:21:45Z Distinct https://community.qlik.com/t5/QlikView/Distinct/m-p/1457954#M795276 <HTML><HEAD></HEAD><BODY><P>Good morning everyone !</P><P></P><P>Please, find below my request :</P><P></P><P>I would like to remove the duplicates in a column...</P><P>My application : TABLE in UPPER, fields lowercase</P><P>FOLDER:</P><P>idclient,</P><P>yearpurchase</P><P></P><P>It is possible to sort on each of client compared by year of purchase ? DISTINCT but how can I insert it ...</P><P>Someone can help me please ...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Distinct/m-p/1457954#M795276 ab92 2020-11-25T16:16:04Z Re: Distinct https://community.qlik.com/t5/QlikView/Distinct/m-p/1457955#M795277 <HTML><HEAD></HEAD><BODY><P>Please clarify more...</P></BODY></HTML> Wed, 03 Jan 2018 09:55:13 GMT https://community.qlik.com/t5/QlikView/Distinct/m-p/1457955#M795277 prma7799 2018-01-03T09:55:13Z Re: Distinct https://community.qlik.com/t5/QlikView/Distinct/m-p/1457956#M795278 <HTML><HEAD></HEAD><BODY><P>try</P><P></P><P>table:</P><P>load ,</P><P>upper(names) as Names</P><P></P><P>from table ;</P><P></P><P>front end</P><P></P><P>use exp&nbsp; :&nbsp;&nbsp;&nbsp; count(Distinct Names)</P></BODY></HTML> Wed, 03 Jan 2018 09:58:27 GMT https://community.qlik.com/t5/QlikView/Distinct/m-p/1457956#M795278 Chanty4u 2018-01-03T09:58:27Z Re: Distinct https://community.qlik.com/t5/QlikView/Distinct/m-p/1457957#M795279 <HTML><HEAD></HEAD><BODY><P>Hi Chanty, Many thanks for your quick feedback it's working I I don't find <SPAN class="short_text" lang="en">the nomenclature of distinct</SPAN><SPAN class="trans-verified-button goog-toolbar-button"><SPAN class="jfk-button-img"></SPAN></SPAN>...</P><P></P><P><SPAN class="short_text" lang="en">If I want to create this same request in my script ?<SPAN class="short_text" lang="en"></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"></SPAN></P><P><SPAN class="short_text" lang="en"></SPAN></P><P><SPAN class="short_text" lang="en"></SPAN></P></BODY></HTML> Wed, 03 Jan 2018 10:18:44 GMT https://community.qlik.com/t5/QlikView/Distinct/m-p/1457957#M795279 ab92 2018-01-03T10:18:44Z Re: Distinct https://community.qlik.com/t5/QlikView/Distinct/m-p/1457958#M795280 <HTML><HEAD></HEAD><BODY><P>You can try like below </P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">table:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">load<STRONG> Distinct </STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">upper(names) as Names</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">from table ;</P></BODY></HTML> Wed, 03 Jan 2018 10:20:55 GMT https://community.qlik.com/t5/QlikView/Distinct/m-p/1457958#M795280 prma7799 2018-01-03T10:20:55Z Re: Distinct https://community.qlik.com/t5/QlikView/Distinct/m-p/1457959#M795281 <HTML><HEAD></HEAD><BODY><P>I try this is not working, Qlikview doesn't accept my expression but is worling ..</P><P></P><P>CLI_DISTINCT:<BR /> <SPAN style="color: #0000ff;">noconcatenate</SPAN> <STRONG style="color: #0000ff;">load</STRONG><BR />IDCLIENT,</P><P>YEARpurchase<BR /> <BR /> <SPAN style="color: #0000ff;">resident</SPAN> DOSSIER_1; <BR /> <BR /> <SPAN style="color: #0000ff;">left</SPAN> <SPAN style="color: #0000ff;">join</SPAN> (CLI_DISTINCT)<BR /> <BR />CLI_DISTINCT1:<BR /> <SPAN style="color: #0000ff;">noconcatenate</SPAN> <STRONG style="color: #0000ff;">load</STRONG><BR /> *<BR /> <SPAN style="color: #0000ff;">resident</SPAN> CLI_DISTINCT; <BR /> <BR />CLI_DISTINCT2:<BR /> <SPAN style="color: #0000ff;">noconcatenate</SPAN> <STRONG style="color: #0000ff;">load</STRONG><BR /> <SPAN style="color: #0000ff;">distinct</SPAN>*<BR /> <BR /> <SPAN style="color: #0000ff;">resident</SPAN> CLI_DISTINCT; <BR /> <BR /> <STRONG style="color: #0000ff;">DROP</STRONG> <SPAN style="color: #0000ff;">Tables</SPAN> CLI_DISTINCT; </P></BODY></HTML> Wed, 03 Jan 2018 10:21:45 GMT https://community.qlik.com/t5/QlikView/Distinct/m-p/1457959#M795281 ab92 2018-01-03T10:21:45Z Re: Distinct https://community.qlik.com/t5/QlikView/Distinct/m-p/1457960#M795282 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">we agree that the duplicate is deleted from the second display in the column ... </SPAN></P><P><SPAN lang="en"></SPAN></P><P><SPAN lang="en">Sorry, I don't use the right world I thing, t</SPAN><SPAN lang="en">he id of client <SPAN class="short_text" lang="en">these are numbers... </SPAN></SPAN></P></BODY></HTML> Wed, 03 Jan 2018 10:24:28 GMT https://community.qlik.com/t5/QlikView/Distinct/m-p/1457960#M795282 ab92 2018-01-03T10:24:28Z Re: Distinct https://community.qlik.com/t5/QlikView/Distinct/m-p/1457961#M795283 <HTML><HEAD></HEAD><BODY><P>can't you just use group by with a resident load? so load your data, then</P><P></P><P>QUALIFY *;</P><P>client_year:</P><P>LOAD</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">only(idclient),</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">only(yearpurchase)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RESIDENT table1</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">GROUP BY </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">idclient,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">yearpurchase;</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">assuming you have called your first table 'table1'. 'Qualify' will ensure that the table doesn't link to your existing table, 'only' is needed as an aggregation function to enable grouping to work</P></BODY></HTML> Wed, 03 Jan 2018 14:34:11 GMT https://community.qlik.com/t5/QlikView/Distinct/m-p/1457961#M795283 Ben_P 2018-01-03T14:34:11Z