https://community.qlik.com/t5/QlikView/expression-to-display-just-highest-value-on-a-table/m-p/1509961#M599723 <P>If you want to show this in a Text Object (or other object) outside the table then&nbsp;<BR /><BR />Max(Aggr(<SPAN>Count(NEWKEYID)-Count(PatientsNotAssessed_ID), Hospital))<BR /><BR />should work. This will give you the maximum value of the formula calculated by Hospital.</SPAN></P> Tue, 20 Nov 2018 18:05:11 GMT lblumenfeld 2018-11-20T18:05:11Z https://community.qlik.com/t5/QlikView/expression-to-display-just-highest-value-on-a-table/m-p/1509933#M599722 <P>Hi guys I want a do a table where the</P><P>Dimension is called 'hospital '</P><P>Expression=&nbsp;&nbsp;&nbsp;</P><P>'Count(NEWKEYID)-Count(PatientsNotAssessed_ID)'</P><P>&nbsp;</P><P>What expression can I use just to display the <STRONG>highest value</STRONG> on the table</P> Tue, 20 Nov 2018 16:50:55 GMT https://community.qlik.com/t5/QlikView/expression-to-display-just-highest-value-on-a-table/m-p/1509933#M599722 sweens78 2018-11-20T16:50:55Z https://community.qlik.com/t5/QlikView/expression-to-display-just-highest-value-on-a-table/m-p/1509961#M599723 <P>If you want to show this in a Text Object (or other object) outside the table then&nbsp;<BR /><BR />Max(Aggr(<SPAN>Count(NEWKEYID)-Count(PatientsNotAssessed_ID), Hospital))<BR /><BR />should work. This will give you the maximum value of the formula calculated by Hospital.</SPAN></P> Tue, 20 Nov 2018 18:05:11 GMT https://community.qlik.com/t5/QlikView/expression-to-display-just-highest-value-on-a-table/m-p/1509961#M599723 lblumenfeld 2018-11-20T18:05:11Z