topic maximum value by dimension in a table in QlikView https://community.qlik.com/t5/QlikView/maximum-value-by-dimension-in-a-table/m-p/201404#M59528 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with two dimension columns (state and city) and several expression columns (revenue, units, revenue-per-unit). I want a new column that shows the highest revenue-per-unit of any city in each state, on all the city records. (i.e., the same value for all cities in each state) It seems I should be able to use 'rangemax' and 'before', but I can't figure it out.</P><P>Thanks</P></BODY></HTML> Wed, 06 Apr 2011 19:15:28 GMT 2011-04-06T19:15:28Z maximum value by dimension in a table https://community.qlik.com/t5/QlikView/maximum-value-by-dimension-in-a-table/m-p/201404#M59528 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with two dimension columns (state and city) and several expression columns (revenue, units, revenue-per-unit). I want a new column that shows the highest revenue-per-unit of any city in each state, on all the city records. (i.e., the same value for all cities in each state) It seems I should be able to use 'rangemax' and 'before', but I can't figure it out.</P><P>Thanks</P></BODY></HTML> Wed, 06 Apr 2011 19:15:28 GMT https://community.qlik.com/t5/QlikView/maximum-value-by-dimension-in-a-table/m-p/201404#M59528 2011-04-06T19:15:28Z