topic Rating in dimension (pivot or strong table) in QlikView https://community.qlik.com/t5/QlikView/Rating-in-dimension-pivot-or-strong-table/m-p/366967#M493620 <HTML><HEAD></HEAD><BODY><P>=Rank(sum(Qty),4,1) its work! mode 4 and format 1.</P><P></P><P><A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/jason.michaelides" id="jive-3098526277475446620021" style="background-color: #f9f9f9; font-size: 12px; color: #007fc0; font-weight: bold; font-family: Arial; text-align: center;">Jason Michaelides</A>, tnx for help!</P></BODY></HTML> Thu, 24 May 2012 07:43:56 GMT 2012-05-24T07:43:56Z Rating in dimension (pivot or strong table) https://community.qlik.com/t5/QlikView/Rating-in-dimension-pivot-or-strong-table/m-p/366964#M493617 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Category</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Item</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Quantity</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Rating_quantity</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Rating_price</STRONG></SPAN></TH></TR><TR><TD>food</TD><TD>Milk</TD><TD>17</TD><TD>2</TD><TD>50</TD><TD>2</TD></TR><TR><TD>food</TD><TD>Cola</TD><TD>10</TD><TD>4</TD><TD>19</TD><TD>3</TD></TR><TR><TD>food</TD><TD>Cake</TD><TD>22</TD><TD>1</TD><TD>70</TD><TD>1</TD></TR><TR><TD>food</TD><TD>Banana</TD><TD>7</TD><TD>5</TD><TD>16</TD><TD>4</TD></TR><TR><TD>food</TD><TD>Сookies</TD><TD>14</TD><TD>3</TD><TD>5</TD><TD>5</TD></TR><TR><TD>furniture</TD><TD>Chair</TD><TD>4</TD><TD>4</TD><TD>100</TD><TD>2</TD></TR><TR><TD>furniture</TD><TD>Table</TD><TD>3</TD><TD>5</TD><TD>90</TD><TD>3</TD></TR><TR><TD>furniture</TD><TD>Sofa</TD><TD>6</TD><TD>2</TD><TD>30</TD><TD>6</TD></TR><TR><TD>furniture</TD><TD>bla1</TD><TD>8</TD><TD>1</TD><TD>80</TD><TD>4</TD></TR><TR><TD>furniture</TD><TD>bla2</TD><TD>5</TD><TD>3</TD><TD>75</TD><TD>5</TD></TR><TR><TD>furniture</TD><TD>bla3</TD><TD>1</TD><TD>6</TD><TD>110</TD><TD>1</TD></TR></TBODY></TABLE><P></P><P><STRONG>Category</STRONG> and <STRONG>Item</STRONG> is dimension.</P><P>How can i do<STRONG> Rating_quantity </STRONG>and <STRONG>Rating_price? (</STRONG>Rating in category)</P><P>Pivot or Strong table - unimportant.</P><P></P><P>Thank you!!</P></BODY></HTML> Thu, 24 May 2012 07:00:57 GMT https://community.qlik.com/t5/QlikView/Rating-in-dimension-pivot-or-strong-table/m-p/366964#M493617 2012-05-24T07:00:57Z Rating in dimension (pivot or strong table) https://community.qlik.com/t5/QlikView/Rating-in-dimension-pivot-or-strong-table/m-p/366965#M493618 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>Rank(Sum(TOTAL &lt;Category&gt; Quantity))</P><P>and</P><P>Rank(Sum(TOTAL &lt;Category&gt; Price))</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Thu, 24 May 2012 07:14:46 GMT https://community.qlik.com/t5/QlikView/Rating-in-dimension-pivot-or-strong-table/m-p/366965#M493618 Jason_Michaelides 2012-05-24T07:14:46Z Rating in dimension (pivot or strong table) https://community.qlik.com/t5/QlikView/Rating-in-dimension-pivot-or-strong-table/m-p/366966#M493619 <HTML><HEAD></HEAD><BODY><P>the result is min-max:</P><P>1-1322</P><P>1-1322</P><P>1-1322</P><P>1-1322</P><P>1-2372</P><P>1-2372</P><P>1-2372</P><P>1-2372</P></BODY></HTML> Thu, 24 May 2012 07:25:03 GMT https://community.qlik.com/t5/QlikView/Rating-in-dimension-pivot-or-strong-table/m-p/366966#M493619 2012-05-24T07:25:03Z Rating in dimension (pivot or strong table) https://community.qlik.com/t5/QlikView/Rating-in-dimension-pivot-or-strong-table/m-p/366967#M493620 <HTML><HEAD></HEAD><BODY><P>=Rank(sum(Qty),4,1) its work! mode 4 and format 1.</P><P></P><P><A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/jason.michaelides" id="jive-3098526277475446620021" style="background-color: #f9f9f9; font-size: 12px; color: #007fc0; font-weight: bold; font-family: Arial; text-align: center;">Jason Michaelides</A>, tnx for help!</P></BODY></HTML> Thu, 24 May 2012 07:43:56 GMT https://community.qlik.com/t5/QlikView/Rating-in-dimension-pivot-or-strong-table/m-p/366967#M493620 2012-05-24T07:43:56Z