topic Min & Max in QlikView https://community.qlik.com/t5/QlikView/Min-Max/m-p/184454#M1286298 <HTML><HEAD></HEAD><BODY><P>Is this what you are looking for? See enclosed.</P></BODY></HTML> Wed, 03 Feb 2010 00:37:38 GMT disqr_rm 2010-02-03T00:37:38Z Min & Max https://community.qlik.com/t5/QlikView/Min-Max/m-p/184453#M1286293 <HTML><HEAD></HEAD><BODY><P>Sure there is an easy solution to this, but am new to this and can't work it out....</P><P>I have a straight table</P><P>Company | Headcount | Min | Max</P><P>Headcount is a sparkline chart based on a 12 month trend for the selected year for each company in the table.</P><P>I would like to show the min and max months headcount for each company but can't work out how!</P><P>Thanks</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Min-Max/m-p/184453#M1286293 2026-01-26T18:19:17Z Min & Max https://community.qlik.com/t5/QlikView/Min-Max/m-p/184454#M1286298 <HTML><HEAD></HEAD><BODY><P>Is this what you are looking for? See enclosed.</P></BODY></HTML> Wed, 03 Feb 2010 00:37:38 GMT https://community.qlik.com/t5/QlikView/Min-Max/m-p/184454#M1286298 disqr_rm 2010-02-03T00:37:38Z Min & Max https://community.qlik.com/t5/QlikView/Min-Max/m-p/184455#M1286302 <HTML><HEAD></HEAD><BODY><P>Thanks....so yes that is what I want....</P><P>guess the difference is that Headcount in the table is an expression.... count(distinct [Employee Number])</P><P>I was trying to do max on the expression but returning nothing. I know I could put something in the load script for headcount but wondering if there is a way of getting the max and min when it's an expression</P></BODY></HTML> Wed, 03 Feb 2010 00:55:27 GMT https://community.qlik.com/t5/QlikView/Min-Max/m-p/184455#M1286302 2010-02-03T00:55:27Z