topic Unique Dimension Values in Chart/Table in App Development https://community.qlik.com/t5/App-Development/Unique-Dimension-Values-in-Chart-Table/m-p/1644600#M48074 <P>Hi,</P><P>We have one table format something like below:</P><TABLE><TBODY><TR><TD>ID</TD><TD>Name</TD><TD>Region</TD></TR><TR><TD>111</TD><TD>ABC</TD><TD>America, London, Singapore</TD></TR><TR><TD>222</TD><TD>BCD</TD><TD>Dubai, Japan</TD></TR><TR><TD>333</TD><TD>CDE</TD><TD>Singapore</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In script have used sub field to make, Region to show only one country, something like below</P><TABLE><TBODY><TR><TD>ID</TD><TD>Name</TD><TD>Region</TD></TR><TR><TD>111</TD><TD>ABC</TD><TD>America</TD></TR><TR><TD>111</TD><TD>ABC</TD><TD>London</TD></TR><TR><TD>111</TD><TD>ABC</TD><TD>Singapore</TD></TR><TR><TD>222</TD><TD>BCD</TD><TD>Dubai</TD></TR><TR><TD>222</TD><TD>BCD</TD><TD>Japan</TD></TR><TR><TD>333</TD><TD>CDE</TD><TD>Singapore</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>now issue is like. for count have taken count(Distinct ID), but when we show in table name format name is getting repeated multiple times based on number of countries</P><P>Is there a way to show only unique names as well in table.</P> Sat, 16 Nov 2024 19:43:04 GMT vardhancse 2024-11-16T19:43:04Z Unique Dimension Values in Chart/Table https://community.qlik.com/t5/App-Development/Unique-Dimension-Values-in-Chart-Table/m-p/1644600#M48074 <P>Hi,</P><P>We have one table format something like below:</P><TABLE><TBODY><TR><TD>ID</TD><TD>Name</TD><TD>Region</TD></TR><TR><TD>111</TD><TD>ABC</TD><TD>America, London, Singapore</TD></TR><TR><TD>222</TD><TD>BCD</TD><TD>Dubai, Japan</TD></TR><TR><TD>333</TD><TD>CDE</TD><TD>Singapore</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In script have used sub field to make, Region to show only one country, something like below</P><TABLE><TBODY><TR><TD>ID</TD><TD>Name</TD><TD>Region</TD></TR><TR><TD>111</TD><TD>ABC</TD><TD>America</TD></TR><TR><TD>111</TD><TD>ABC</TD><TD>London</TD></TR><TR><TD>111</TD><TD>ABC</TD><TD>Singapore</TD></TR><TR><TD>222</TD><TD>BCD</TD><TD>Dubai</TD></TR><TR><TD>222</TD><TD>BCD</TD><TD>Japan</TD></TR><TR><TD>333</TD><TD>CDE</TD><TD>Singapore</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>now issue is like. for count have taken count(Distinct ID), but when we show in table name format name is getting repeated multiple times based on number of countries</P><P>Is there a way to show only unique names as well in table.</P> Sat, 16 Nov 2024 19:43:04 GMT https://community.qlik.com/t5/App-Development/Unique-Dimension-Values-in-Chart-Table/m-p/1644600#M48074 vardhancse 2024-11-16T19:43:04Z Re: Unique Dimension Values in Chart/Table https://community.qlik.com/t5/App-Development/Unique-Dimension-Values-in-Chart-Table/m-p/1644621#M48076 <P>Use Pivot Table</P> Fri, 08 Nov 2019 07:18:12 GMT https://community.qlik.com/t5/App-Development/Unique-Dimension-Values-in-Chart-Table/m-p/1644621#M48076 Anil_Babu_Samineni 2019-11-08T07:18:12Z Re: Unique Dimension Values in Chart/Table https://community.qlik.com/t5/App-Development/Unique-Dimension-Values-in-Chart-Table/m-p/1644720#M48082 <P>Hi Varda,</P><P>could you please attach&nbsp; qvf file, So that i&nbsp; can check.</P><P>&nbsp;</P> Fri, 08 Nov 2019 10:13:48 GMT https://community.qlik.com/t5/App-Development/Unique-Dimension-Values-in-Chart-Table/m-p/1644720#M48082 mahaveerbiraj 2019-11-08T10:13:48Z