topic Re: Máximo por Departamento in QlikView https://community.qlik.com/t5/QlikView/M%C3%A1ximo-por-Departamento/m-p/521570#M194900 <HTML><HEAD></HEAD><BODY><P>One possible solution is with dimension limit (third tab in chart properites), see attachement</P><P>Regards</P></BODY></HTML> Mon, 23 Dec 2013 22:07:23 GMT maxgro 2013-12-23T22:07:23Z Máximo por Departamento https://community.qlik.com/t5/QlikView/M%C3%A1ximo-por-Departamento/m-p/521569#M194899 <HTML><HEAD></HEAD><BODY><P>Buenas tardes,</P><P></P><P>Tengo el siguiente caso:</P><P></P><P>Tengo las cantidades de ventas de varios productos por departamentos y quisiera saber cual es el producto que más se vendio en cada departamento, tengo la siguiente table:</P><P></P><P><SPAN style="font-family: courier new,courier;">Departamento&nbsp;&nbsp; Producto&nbsp;&nbsp;&nbsp;&nbsp; Ventas</SPAN></P><P><SPAN style="font-family: courier new,courier;">============&nbsp;&nbsp; ========&nbsp;&nbsp;&nbsp;&nbsp; ======</SPAN></P><P><SPAN style="font-family: courier new,courier;">Ica&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Galleta&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500</SPAN></P><P><SPAN style="font-family: courier new,courier;">Ica&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gaseosa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 890</SPAN></P><P><SPAN style="font-family: courier new,courier;">Lima&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Chocolate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2100</SPAN></P><P><SPAN style="font-family: courier new,courier;">Lima&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Caramelo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015</SPAN></P><P><SPAN style="font-family: courier new,courier;">Lima&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Galleta&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2085</SPAN></P><P></P><P>Y quisiera obtener la siguiente tabla:</P><P></P><P><SPAN style="font-family: courier new,courier;">Departamento&nbsp;&nbsp; Producto&nbsp;&nbsp;&nbsp;&nbsp; Ventas</SPAN></P><P><SPAN style="font-family: courier new,courier;">============&nbsp;&nbsp; ========&nbsp;&nbsp;&nbsp;&nbsp; ======</SPAN></P><P><SPAN style="font-family: courier new,courier;">Ica&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Galleta&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500<BR /></SPAN></P><P><SPAN style="font-family: courier new,courier;">Lima&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Chocolate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2100</SPAN></P><P></P><P>Espero su ayuda!!</P><P></P><P>Gracias</P></BODY></HTML> Mon, 23 Dec 2013 21:50:25 GMT https://community.qlik.com/t5/QlikView/M%C3%A1ximo-por-Departamento/m-p/521569#M194899 coddra_6 2013-12-23T21:50:25Z Re: Máximo por Departamento https://community.qlik.com/t5/QlikView/M%C3%A1ximo-por-Departamento/m-p/521570#M194900 <HTML><HEAD></HEAD><BODY><P>One possible solution is with dimension limit (third tab in chart properites), see attachement</P><P>Regards</P></BODY></HTML> Mon, 23 Dec 2013 22:07:23 GMT https://community.qlik.com/t5/QlikView/M%C3%A1ximo-por-Departamento/m-p/521570#M194900 maxgro 2013-12-23T22:07:23Z Re: Máximo por Departamento https://community.qlik.com/t5/QlikView/M%C3%A1ximo-por-Departamento/m-p/521571#M194901 <HTML><HEAD></HEAD><BODY><P>a second solution, chart with</P><P>dimension:&nbsp; Departamento</P><P>expression: max(Ventas)</P><P>expression: FirstSortedValue(Producto, -Ventas)</P></BODY></HTML> Mon, 23 Dec 2013 22:21:02 GMT https://community.qlik.com/t5/QlikView/M%C3%A1ximo-por-Departamento/m-p/521571#M194901 maxgro 2013-12-23T22:21:02Z