topic Re: Problem in calculate value in QlikView https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53396#M8887 <HTML><HEAD></HEAD><BODY><P>You can restrict in Dimensions limit to show top 10 best buying customers.</P><P><IMG alt="top 10.PNG" class="jive-image image-1" src="/legacyfs/online/199995_top 10.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 18 Apr 2018 07:21:11 GMT pooja_prabhu_n 2018-04-18T07:21:11Z Problem in calculate value https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53393#M8884 <HTML><HEAD></HEAD><BODY><P>dear,</P><P></P><P>I have two table with this fields</P><P></P><P>ItemID&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; ItemTitle</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IT1</P><P><SPAN style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IT2</SPAN></P><P><SPAN style="font-size: 13.3333px;">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IT3</SPAN></P><P><SPAN style="font-size: 13.3333px;">4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IT4</SPAN></P><P><SPAN style="font-size: 13.3333px;">5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IT5</SPAN></P><P><SPAN style="font-size: 13.3333px;">.....</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P><P>CustomerName&nbsp; |&nbsp;&nbsp; Item Title&nbsp; |&nbsp;&nbsp; Quantity&nbsp;&nbsp; </P><P>C1&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; IT1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>C2&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; IT2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P><SPAN style="font-size: 13.3333px;">C1&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; IT1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</SPAN></P><P><SPAN style="font-size: 13.3333px;">C1&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; IT2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</SPAN></P><P><SPAN style="font-size: 13.3333px;">C3&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; IT1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</SPAN></P><P><SPAN style="font-size: 13.3333px;">C2&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; IT2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</SPAN></P><P>............</P><P>.........</P><P>..........</P><P></P><P>when i select a customer i want display bellow values:</P><P></P><P>ItemTitle&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; TotalQuantity for all Customer&nbsp; |&nbsp; Total Quantity of Top(10) of customer buy more | Total Quantity of selected customer&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 18 Apr 2018 06:49:08 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53393#M8884 mrbqlik2009 2018-04-18T06:49:08Z Re: Problem in calculate value https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53394#M8885 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You are not stating an issue, you are asking us how to do a standard visualization? How far did you get with your data model and visualizations before coming to the forum?</P></BODY></HTML> Wed, 18 Apr 2018 07:02:31 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53394#M8885 niclaz79 2018-04-18T07:02:31Z Re: Problem in calculate value https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53395#M8886 <HTML><HEAD></HEAD><BODY><P>My problem is that i can't calculate top(10) Quantity of best buying customers.</P></BODY></HTML> Wed, 18 Apr 2018 07:10:28 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53395#M8886 mrbqlik2009 2018-04-18T07:10:28Z Re: Problem in calculate value https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53396#M8887 <HTML><HEAD></HEAD><BODY><P>You can restrict in Dimensions limit to show top 10 best buying customers.</P><P><IMG alt="top 10.PNG" class="jive-image image-1" src="/legacyfs/online/199995_top 10.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 18 Apr 2018 07:21:11 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53396#M8887 pooja_prabhu_n 2018-04-18T07:21:11Z Re: Problem in calculate value https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53397#M8888 <HTML><HEAD></HEAD><BODY><P>Just try the below 3 expression</P><P></P><P>TotalQuantity for all Customer&nbsp;&nbsp; = Sum (total&lt;customer&gt; Amount)</P><P></P><P>Total Quantity of Top(10) of customer buy more&nbsp; = Sum ({&lt;customer={"=Rank(sum(amount)&lt;=10)"}&gt;} Amount)</P><P></P><P>Total Quantity of selected customer&nbsp;&nbsp;&nbsp; = Sum ( Amount)</P></BODY></HTML> Thu, 19 Apr 2018 05:20:01 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculate-value/m-p/53397#M8888 qliksus 2018-04-19T05:20:01Z