topic Re: Explain this one please in QlikView https://community.qlik.com/t5/QlikView/Explain-this-one-please/m-p/609548#M1117107 <HTML><HEAD></HEAD><BODY><P>Click on the Product dimension, then click "Suppress When Value Is Null":</P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/53542_pastedImage_2.png" style="width: 620px; height: 542px;" /></P></BODY></HTML> Thu, 20 Feb 2014 13:51:15 GMT Nicole-Smith 2014-02-20T13:51:15Z Explain this one please https://community.qlik.com/t5/QlikView/Explain-this-one-please/m-p/609545#M1117104 <HTML><HEAD></HEAD><BODY><P>Hai every one......Iam a new to Qlikview.............</P><P></P><P></P><P>I have Customer table in that table fields are </P><P>Customer,Product,Q1,Q2,Q3,Q4&nbsp;&nbsp; </P><P>using this table find this........</P><P>1.find the top two products in each customer...</P><P>2.<SPAN style="color: black; font-size: 10pt; font-family: Tahoma;">Finding the biggest customer for a quarter</SPAN></P><P><SPAN style="font-size: 8pt; font-family: Tahoma; color: black;">3.<SPAN style="font-size: 8pt; font-family: Tahoma; color: black;">Determining which customers purchase the most of each product.</SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Explain this one.... </SPAN></P></BODY></HTML> Wed, 19 Feb 2014 18:48:30 GMT https://community.qlik.com/t5/QlikView/Explain-this-one-please/m-p/609545#M1117104 2014-02-19T18:48:30Z Re: Explain this one please https://community.qlik.com/t5/QlikView/Explain-this-one-please/m-p/609546#M1117105 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">here you can find a very detailed explanation</SPAN></P><P><A href="https://community.qlik.com/docs/DOC-5187">Show Top Performers</A></P></BODY></HTML> Wed, 19 Feb 2014 21:21:22 GMT https://community.qlik.com/t5/QlikView/Explain-this-one-please/m-p/609546#M1117105 maxgro 2014-02-19T21:21:22Z Re: Explain this one please https://community.qlik.com/t5/QlikView/Explain-this-one-please/m-p/609547#M1117106 <HTML><HEAD></HEAD><BODY><P>I was written the code in Dimension tab like this.....</P><P>=Aggr(If(rank(sum([Qtr 3]),1)&lt;=2,Product),Customer,Product)</P><P>but the result is displayed like This........</P><P>Customer&nbsp;&nbsp; Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qtr3</P><P>alfki&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; chartreuse&nbsp;&nbsp;&nbsp;&nbsp; 543</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 789</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -----&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 905</P><P> total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2209</P><P></P><P></P><P></P><P></P><P>like this&nbsp;&nbsp; </P><P></P><P></P><P>here what is the third row in the product column....</P><P>Iam using Pivot table.</P><P>what is the code to display only two top Products From&nbsp; Each Customer</P></BODY></HTML> Thu, 20 Feb 2014 05:56:24 GMT https://community.qlik.com/t5/QlikView/Explain-this-one-please/m-p/609547#M1117106 2014-02-20T05:56:24Z Re: Explain this one please https://community.qlik.com/t5/QlikView/Explain-this-one-please/m-p/609548#M1117107 <HTML><HEAD></HEAD><BODY><P>Click on the Product dimension, then click "Suppress When Value Is Null":</P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/53542_pastedImage_2.png" style="width: 620px; height: 542px;" /></P></BODY></HTML> Thu, 20 Feb 2014 13:51:15 GMT https://community.qlik.com/t5/QlikView/Explain-this-one-please/m-p/609548#M1117107 Nicole-Smith 2014-02-20T13:51:15Z