https://community.qlik.com/t5/QlikView/Get-only-Distinct-values/m-p/1528352#M748766 <P>Try this</P><PRE>=Capitalize(Concat(<FONT color="#FF0000">DISTINCT</FONT> [Company Name],', '))</PRE> Wed, 09 Jan 2019 12:47:52 GMT sunny_talwar 2019-01-09T12:47:52Z https://community.qlik.com/t5/QlikView/Get-only-Distinct-values/m-p/1528349#M748765 <P>Hi All,</P><P>The below expression is giving me duplicate value, Can we get only distinct&nbsp;values?</P><P>=Capitalize(Concat([Company Name],', '))</P> Sat, 16 Nov 2024 04:48:49 GMT https://community.qlik.com/t5/QlikView/Get-only-Distinct-values/m-p/1528349#M748765 madhuqliklondon 2024-11-16T04:48:49Z https://community.qlik.com/t5/QlikView/Get-only-Distinct-values/m-p/1528352#M748766 <P>Try this</P><PRE>=Capitalize(Concat(<FONT color="#FF0000">DISTINCT</FONT> [Company Name],', '))</PRE> Wed, 09 Jan 2019 12:47:52 GMT https://community.qlik.com/t5/QlikView/Get-only-Distinct-values/m-p/1528352#M748766 sunny_talwar 2019-01-09T12:47:52Z