topic Re: Distinct Field Value in Straight Table in QlikView https://community.qlik.com/t5/QlikView/Distinct-Field-Value-in-Straight-Table/m-p/122977#M756247 <HTML><HEAD></HEAD><BODY><P>Just use Max(Ver) in your expr. </P><P></P><P>Dim: Filename</P><P>Expr: Max(Ver)</P></BODY></HTML> Wed, 12 Sep 2018 19:16:35 GMT vishsaggi 2018-09-12T19:16:35Z Distinct Field Value in Straight Table https://community.qlik.com/t5/QlikView/Distinct-Field-Value-in-Straight-Table/m-p/122976#M756246 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How do I display Distinct Values of a Field in a chart, like a Straight Table? I know List boxes etc show Distinct values but this is not the case in Tables. I don't want to use Distinct in Load since I need the Field values for other charts.</P><P></P><P>Current Data:</P><P></P><P><STRONG>File Name&nbsp;&nbsp;&nbsp;&nbsp; Ver</STRONG></P><P>FileA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>FileB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>FileA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>Expected Output</P><P></P><P><STRONG>File Name&nbsp;&nbsp;&nbsp;&nbsp; Ver</STRONG></P><P></P><P>FileB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>FileA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>I need to show Unique File Names based on the <STRONG>Maximum Ver</STRONG> number available for them.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Distinct-Field-Value-in-Straight-Table/m-p/122976#M756246 qlikwiz123 2020-11-25T16:16:04Z Re: Distinct Field Value in Straight Table https://community.qlik.com/t5/QlikView/Distinct-Field-Value-in-Straight-Table/m-p/122977#M756247 <HTML><HEAD></HEAD><BODY><P>Just use Max(Ver) in your expr. </P><P></P><P>Dim: Filename</P><P>Expr: Max(Ver)</P></BODY></HTML> Wed, 12 Sep 2018 19:16:35 GMT https://community.qlik.com/t5/QlikView/Distinct-Field-Value-in-Straight-Table/m-p/122977#M756247 vishsaggi 2018-09-12T19:16:35Z Re: Distinct Field Value in Straight Table https://community.qlik.com/t5/QlikView/Distinct-Field-Value-in-Straight-Table/m-p/122978#M756248 <HTML><HEAD></HEAD><BODY><P>Thank you so much Vishwarath</P></BODY></HTML> Wed, 12 Sep 2018 20:30:10 GMT https://community.qlik.com/t5/QlikView/Distinct-Field-Value-in-Straight-Table/m-p/122978#M756248 qlikwiz123 2018-09-12T20:30:10Z