topic Re: Top 10 in Francophones https://community.qlik.com/t5/Francophones/Top-10/m-p/1139714#M8266 <HTML><HEAD></HEAD><BODY><P>What object are you using? Would it be possible to provide a sample to work with?</P></BODY></HTML> Wed, 29 Jun 2016 10:08:53 GMT sunny_talwar 2016-06-29T10:08:53Z Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139711#M8263 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How i can combine two condition for the top 4</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 240px;"><TBODY><TR><TD height="20" width="80">Dim1</TD><TD width="80">Top4</TD><TD width="80">Exp2</TD></TR><TR><TD height="20">a</TD><TD align="right" class="xl63">15%</TD><TD align="right">152</TD></TR><TR><TD height="20">b</TD><TD align="right" class="xl63">12%</TD><TD align="right">125</TD></TR><TR><TD height="20">c</TD><TD align="right" class="xl63"><STRONG style="color: #ff0000;">11%</STRONG></TD><TD align="right"><SPAN style="color: #ff0000;"><STRONG>90</STRONG></SPAN></TD></TR><TR><TD height="20">d </TD><TD align="right" class="xl63"><SPAN style="color: #ff0000;"><STRONG>11%</STRONG></SPAN></TD><TD align="right"><SPAN style="color: #ff0000;"><STRONG>120</STRONG></SPAN></TD></TR></TBODY></TABLE><P></P><P>How i can have this</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 240px;"><TBODY><TR><TD height="20" width="80">Dim1</TD><TD width="80">Top4</TD><TD width="80">Exp2</TD></TR><TR><TD height="20">a</TD><TD align="right" class="xl63">15%</TD><TD align="right">152</TD></TR><TR><TD height="20">b</TD><TD align="right" class="xl63">12%</TD><TD align="right">125</TD></TR><TR><TD height="20">d</TD><TD align="right" class="xl63"><STRONG style="color: #ff0000;">11%</STRONG></TD><TD align="right"><SPAN style="color: #ff0000;"><STRONG>120</STRONG></SPAN></TD></TR><TR><TD height="20">c</TD><TD align="right" class="xl63"><SPAN style="color: #ff0000;"><STRONG>11%</STRONG></SPAN></TD><TD align="right"><SPAN style="color: #ff0000;"><STRONG>90</STRONG></SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>Many thanks</P><P></P><P>Said</P></BODY></HTML> Wed, 29 Jun 2016 09:55:08 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139711#M8263 emteam162 2016-06-29T09:55:08Z Re: Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139712#M8264 <HTML><HEAD></HEAD><BODY><P>Are you looking for change of sort order?</P></BODY></HTML> Wed, 29 Jun 2016 09:56:21 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139712#M8264 sunny_talwar 2016-06-29T09:56:21Z Re: Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139713#M8265 <HTML><HEAD></HEAD><BODY><P>yes, if i have Value of each item are equal then in my exemple i have item d and c are equal then i see second condition</P><P>(exp2) i take item how have more </P></BODY></HTML> Wed, 29 Jun 2016 10:07:17 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139713#M8265 emteam162 2016-06-29T10:07:17Z Re: Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139714#M8266 <HTML><HEAD></HEAD><BODY><P>What object are you using? Would it be possible to provide a sample to work with?</P></BODY></HTML> Wed, 29 Jun 2016 10:08:53 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139714#M8266 sunny_talwar 2016-06-29T10:08:53Z Re: Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139715#M8267 <HTML><HEAD></HEAD><BODY><P>Here is an exemple</P></BODY></HTML> Wed, 29 Jun 2016 10:27:41 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139715#M8267 emteam162 2016-06-29T10:27:41Z Re: Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139716#M8268 <HTML><HEAD></HEAD><BODY><P>You can use in Sort Tab</P><P>Sum(GP%)*10000+Sum(GP)</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Wed, 29 Jun 2016 10:31:50 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139716#M8268 antoniotiman 2016-06-29T10:31:50Z Re: Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139717#M8269 <HTML><HEAD></HEAD><BODY><P>May be this as your sort expression:</P><P><STRONG>Sum(Sales-COS)/Sum(Sales)*1000000-Sum(GP)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/129532_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 29 Jun 2016 10:36:42 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139717#M8269 sunny_talwar 2016-06-29T10:36:42Z Re: Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139718#M8270 <HTML><HEAD></HEAD><BODY><P>why you use&nbsp; (*1000000)</P></BODY></HTML> Wed, 29 Jun 2016 12:37:48 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139718#M8270 emteam162 2016-06-29T12:37:48Z Re: Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139719#M8271 <HTML><HEAD></HEAD><BODY><P>To give GP% more weight in the sorting compared to the GP. I would have gone with 100, but since GP% is decimal number, I went with an even higher number. Depending on size of the GP and GP%, I would adjust up or down 10000.</P></BODY></HTML> Wed, 29 Jun 2016 12:41:43 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139719#M8271 sunny_talwar 2016-06-29T12:41:43Z Re: Top 10 https://community.qlik.com/t5/Francophones/Top-10/m-p/1139720#M8272 <HTML><HEAD></HEAD><BODY><P>Thanks its work</P></BODY></HTML> Wed, 29 Jun 2016 13:35:43 GMT https://community.qlik.com/t5/Francophones/Top-10/m-p/1139720#M8272 emteam162 2016-06-29T13:35:43Z