topic Re: Rank in Table in QlikView https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319269#M409064 <HTML><HEAD></HEAD><BODY><P>I want to get </P><P>&nbsp; </P><TABLE style="width: 294px;"><TBODY><TR><TD class="xl24" height="17" width="98">Product1</TD><TD class="xl24" width="98">1.08.2017</TD><TD align="right" class="xl24" width="98">3</TD></TR><TR><TD class="xl24" height="17">Product1</TD><TD class="xl24">2.08.2017</TD><TD align="right" class="xl24">1</TD></TR><TR><TD class="xl24" height="17">Product1</TD><TD class="xl24">3.08.2017</TD><TD align="right" class="xl24">2</TD></TR><TR><TD class="xl24" height="17">Product2</TD><TD class="xl24">1.08.2017</TD><TD align="right" class="xl24">1</TD></TR><TR><TD class="xl24" height="17">Product2</TD><TD class="xl24">2.08.2017</TD><TD align="right" class="xl24">2</TD></TR><TR><TD class="xl24" height="17">Product2</TD><TD class="xl24">3.08.2017</TD><TD align="right" class="xl24">3</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 31 Jul 2017 11:05:33 GMT MA1 2017-07-31T11:05:33Z Rank in Table https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319266#M409061 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I try to get Rank for each Products, but now I am getting only for first Product.</P><P></P><P>Maybe Can you help me?</P><P></P><P>Thanks a lot</P></BODY></HTML> Mon, 31 Jul 2017 10:57:16 GMT https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319266#M409061 MA1 2017-07-31T10:57:16Z Re: Rank in Table https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319267#M409062 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Rank</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #800000; font-size: 8pt;">Q</SPAN><SPAN style="font-size: 8pt;">) ,4) </SPAN></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171911_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P></P></BODY></HTML> Mon, 31 Jul 2017 11:00:44 GMT https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319267#M409062 zhadrakas 2017-07-31T11:00:44Z Re: Rank in Table https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319268#M409063 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><EM>=<STRONG>aggr(</STRONG> Rank( total Sum( Q) ,4), </EM><STRONG><EM>Date, Product)</EM></STRONG></P><P><STRONG><EM><BR /></EM></STRONG></P><P><EM>Or simply</EM></P><P><STRONG><EM><BR /></EM></STRONG></P><P><EM><EM style="font-size: 13.3333px;">=Rank( total Sum( Q) ,4)</EM></EM></P><P><STRONG><EM><BR /></EM></STRONG></P></BODY></HTML> Mon, 31 Jul 2017 11:01:52 GMT https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319268#M409063 tresB 2017-07-31T11:01:52Z Re: Rank in Table https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319269#M409064 <HTML><HEAD></HEAD><BODY><P>I want to get </P><P>&nbsp; </P><TABLE style="width: 294px;"><TBODY><TR><TD class="xl24" height="17" width="98">Product1</TD><TD class="xl24" width="98">1.08.2017</TD><TD align="right" class="xl24" width="98">3</TD></TR><TR><TD class="xl24" height="17">Product1</TD><TD class="xl24">2.08.2017</TD><TD align="right" class="xl24">1</TD></TR><TR><TD class="xl24" height="17">Product1</TD><TD class="xl24">3.08.2017</TD><TD align="right" class="xl24">2</TD></TR><TR><TD class="xl24" height="17">Product2</TD><TD class="xl24">1.08.2017</TD><TD align="right" class="xl24">1</TD></TR><TR><TD class="xl24" height="17">Product2</TD><TD class="xl24">2.08.2017</TD><TD align="right" class="xl24">2</TD></TR><TR><TD class="xl24" height="17">Product2</TD><TD class="xl24">3.08.2017</TD><TD align="right" class="xl24">3</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 31 Jul 2017 11:05:33 GMT https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319269#M409064 MA1 2017-07-31T11:05:33Z Re: Rank in Table https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319270#M409065 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>If you need ranks product wise use</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Rank(-aggr( Num(Rank( total Sum( Q) ,4)), Date,Product),Product)</SPAN></P></BODY></HTML> Mon, 31 Jul 2017 11:07:55 GMT https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319270#M409065 prat1507 2017-07-31T11:07:55Z Re: Rank in Table https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319271#M409066 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=Aggr(Rank(Sum(Q) ,4), Product, Date)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171909_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 31 Jul 2017 11:11:53 GMT https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319271#M409066 sunny_talwar 2017-07-31T11:11:53Z Re: Rank in Table https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319272#M409067 <HTML><HEAD></HEAD><BODY><P>Thanks a lot</P></BODY></HTML> Mon, 31 Jul 2017 11:13:24 GMT https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319272#M409067 MA1 2017-07-31T11:13:24Z Re: Rank in Table https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319273#M409068 <HTML><HEAD></HEAD><BODY><P>you dont Need so much code</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Rank</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #800000; font-size: 8pt;">Q</SPAN><SPAN style="font-size: 8pt;">) , </SPAN><SPAN style="color: #800000; font-size: 8pt;">Product</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">),4) </SPAN></P></BODY></HTML> Mon, 31 Jul 2017 11:14:35 GMT https://community.qlik.com/t5/QlikView/Rank-in-Table/m-p/1319273#M409068 zhadrakas 2017-07-31T11:14:35Z