https://community.qlik.com/t5/QlikView/How-to-use-this-one-in-SetAnalysis/m-p/229776#M81664 <HTML><HEAD></HEAD><BODY><P>One column for each product with the Company products first..,How to use this one in SetAnalysis..,</P><P></P><P>Please help me..</P></BODY></HTML> Wed, 06 Oct 2010 15:21:08 GMT 2010-10-06T15:21:08Z https://community.qlik.com/t5/QlikView/How-to-use-this-one-in-SetAnalysis/m-p/229776#M81664 <HTML><HEAD></HEAD><BODY><P>One column for each product with the Company products first..,How to use this one in SetAnalysis..,</P><P></P><P>Please help me..</P></BODY></HTML> Wed, 06 Oct 2010 15:21:08 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-one-in-SetAnalysis/m-p/229776#M81664 2010-10-06T15:21:08Z https://community.qlik.com/t5/QlikView/How-to-use-this-one-in-SetAnalysis/m-p/229777#M81665 <HTML><HEAD></HEAD><BODY><P></P><DIV class="O" style="font-weight: bold">If i inderstood your doubt ....something like this:</DIV><DIV class="O" style="font-weight: bold"><BR /></DIV><DIV class="O"><B>sum({$&lt;YOUR_PRODUCT_DIMENSION={'</B>YOUR_PRODUCT'}&gt;} Sales)<BR /></DIV><DIV class="O" style="font-weight: bold"><BR /></DIV><DIV class="O" style="font-weight: bold">for example to sum you sales!!!!!</DIV><BR /><BR /></BODY></HTML> Wed, 06 Oct 2010 15:47:53 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-one-in-SetAnalysis/m-p/229777#M81665 2010-10-06T15:47:53Z https://community.qlik.com/t5/QlikView/How-to-use-this-one-in-SetAnalysis/m-p/229778#M81666 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>You can Add a calculate dimension for get the max product for each Company :</P><P>=Aggr(firstsortedvalue (product , Amount),Company)</P><P></P><P></P></BODY></HTML> Wed, 06 Oct 2010 16:06:00 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-one-in-SetAnalysis/m-p/229778#M81666 2010-10-06T16:06:00Z https://community.qlik.com/t5/QlikView/How-to-use-this-one-in-SetAnalysis/m-p/229779#M81667 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Pull your dimension in pivot chart and make it horizental.</P><P>Attached sreen shots of how to drag and drop dimension ( Product ) from rows to columns.</P><P></P></BODY></HTML> Wed, 06 Oct 2010 17:10:39 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-one-in-SetAnalysis/m-p/229779#M81667 2010-10-06T17:10:39Z