topic How to get default rank in Pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-get-default-rank-in-Pivot-table/m-p/55153#M787756 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P></P><P>My source like below..</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="226"><TBODY><TR><TD height="20" width="64">Name</TD><TD width="64">type</TD><TD width="98">typeid</TD></TR><TR><TD height="20">aaa</TD><TD>nondeal</TD><TD>GRp</TD></TR><TR><TD height="20">bbb</TD><TD>cnf</TD><TD>1X1</TD></TR><TR><TD height="20">ccc</TD><TD>fv</TD><TD>2X1</TD></TR><TR><TD height="20">ddd</TD><TD>nondeal</TD><TD>GRP</TD></TR><TR><TD height="20">fff</TD><TD>cnf</TD><TD>1X1</TD></TR><TR><TD height="20">xxx</TD><TD>FD</TD><TD>2X1</TD></TR><TR><TD height="20">yyy</TD><TD>RD</TD><TD>GRP</TD></TR><TR><TD height="20">zzz</TD><TD>FD</TD><TD>GRP</TD></TR><TR><TD height="20">eee</TD><TD>RD</TD><TD>1X1</TD></TR></TBODY></TABLE><P>from there we need want rank and count of type id.</P><P>but here that count only we need nondeal and cnf,fv this three only need count and remaning as usual display..</P><P></P><P>I am expacted o/p is ..</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 596px;"><TBODY><TR><TD class="xl63" height="17" width="44"></TD><TD class="xl74" width="38"></TD><TD class="xl73" width="86"></TD><TD class="xl64" width="45">type</TD><TD class="xl65" style="border-left: none;" width="42">cnf</TD><TD class="xl65" style="border-left: none;" width="45">FD</TD><TD class="xl65" style="border-left: none;" width="58">FD</TD><TD class="xl66" style="border-left: none;" width="32">fv</TD><TD class="xl65" style="border-left: none;" width="58">nondeal</TD><TD class="xl65" style="border-left: none;" width="49"></TD><TD class="xl66" style="border-left: none;" width="35">RD</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">Name</TD><TD class="xl75">rank</TD><TD class="xl78">no of typeid</TD><TD class="xl68" style="border-top: none;">typeid</TD><TD class="xl65" style="border-top: none; border-left: none;">1X1</TD><TD class="xl65" style="border-top: none; border-left: none;">2X1</TD><TD class="xl65" style="border-top: none; border-left: none;">GRP</TD><TD class="xl69" style="border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;">GRP</TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl69" style="border-left: none;"></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">aaa</TD><TD align="right" class="xl77">1</TD><TD align="right" class="xl77">1</TD><TD class="xl71"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">bbb</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">ccc</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">ddd</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">eee</TD><TD align="right" class="xl77" style="border-top: none;">2</TD><TD align="right" class="xl77" style="border-top: none;">0</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">fff</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">xxx</TD><TD align="right" class="xl77" style="border-top: none;">2</TD><TD align="right" class="xl77" style="border-top: none;">0</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">yyy</TD><TD align="right" class="xl77" style="border-top: none;">2</TD><TD align="right" class="xl77" style="border-top: none;">0</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">zzz</TD><TD align="right" class="xl77" style="border-top: none;">2</TD><TD align="right" class="xl77" style="border-top: none;">0</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0<P></P></TD></TR></TBODY></TABLE><P></P><P>How to get Default rank in pivot table</P><P>Thanks,</P><P>NAni</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z How to get default rank in Pivot table https://community.qlik.com/t5/QlikView/How-to-get-default-rank-in-Pivot-table/m-p/55153#M787756 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P></P><P>My source like below..</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="226"><TBODY><TR><TD height="20" width="64">Name</TD><TD width="64">type</TD><TD width="98">typeid</TD></TR><TR><TD height="20">aaa</TD><TD>nondeal</TD><TD>GRp</TD></TR><TR><TD height="20">bbb</TD><TD>cnf</TD><TD>1X1</TD></TR><TR><TD height="20">ccc</TD><TD>fv</TD><TD>2X1</TD></TR><TR><TD height="20">ddd</TD><TD>nondeal</TD><TD>GRP</TD></TR><TR><TD height="20">fff</TD><TD>cnf</TD><TD>1X1</TD></TR><TR><TD height="20">xxx</TD><TD>FD</TD><TD>2X1</TD></TR><TR><TD height="20">yyy</TD><TD>RD</TD><TD>GRP</TD></TR><TR><TD height="20">zzz</TD><TD>FD</TD><TD>GRP</TD></TR><TR><TD height="20">eee</TD><TD>RD</TD><TD>1X1</TD></TR></TBODY></TABLE><P>from there we need want rank and count of type id.</P><P>but here that count only we need nondeal and cnf,fv this three only need count and remaning as usual display..</P><P></P><P>I am expacted o/p is ..</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 596px;"><TBODY><TR><TD class="xl63" height="17" width="44"></TD><TD class="xl74" width="38"></TD><TD class="xl73" width="86"></TD><TD class="xl64" width="45">type</TD><TD class="xl65" style="border-left: none;" width="42">cnf</TD><TD class="xl65" style="border-left: none;" width="45">FD</TD><TD class="xl65" style="border-left: none;" width="58">FD</TD><TD class="xl66" style="border-left: none;" width="32">fv</TD><TD class="xl65" style="border-left: none;" width="58">nondeal</TD><TD class="xl65" style="border-left: none;" width="49"></TD><TD class="xl66" style="border-left: none;" width="35">RD</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">Name</TD><TD class="xl75">rank</TD><TD class="xl78">no of typeid</TD><TD class="xl68" style="border-top: none;">typeid</TD><TD class="xl65" style="border-top: none; border-left: none;">1X1</TD><TD class="xl65" style="border-top: none; border-left: none;">2X1</TD><TD class="xl65" style="border-top: none; border-left: none;">GRP</TD><TD class="xl69" style="border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;">GRP</TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl69" style="border-left: none;"></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">aaa</TD><TD align="right" class="xl77">1</TD><TD align="right" class="xl77">1</TD><TD class="xl71"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">bbb</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">ccc</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">ddd</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">eee</TD><TD align="right" class="xl77" style="border-top: none;">2</TD><TD align="right" class="xl77" style="border-top: none;">0</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">fff</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD align="right" class="xl77" style="border-top: none;">1</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">xxx</TD><TD align="right" class="xl77" style="border-top: none;">2</TD><TD align="right" class="xl77" style="border-top: none;">0</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">yyy</TD><TD align="right" class="xl77" style="border-top: none;">2</TD><TD align="right" class="xl77" style="border-top: none;">0</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">zzz</TD><TD align="right" class="xl77" style="border-top: none;">2</TD><TD align="right" class="xl77" style="border-top: none;">0</TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0<P></P></TD></TR></TBODY></TABLE><P></P><P>How to get Default rank in pivot table</P><P>Thanks,</P><P>NAni</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-default-rank-in-Pivot-table/m-p/55153#M787756 Anonymous 2020-11-25T16:16:04Z Re: How to get default rank in Pivot table https://community.qlik.com/t5/QlikView/How-to-get-default-rank-in-Pivot-table/m-p/55154#M787757 <HTML><HEAD></HEAD><BODY><P>FYI</P></BODY></HTML> Wed, 11 Apr 2018 08:04:06 GMT https://community.qlik.com/t5/QlikView/How-to-get-default-rank-in-Pivot-table/m-p/55154#M787757 MK_QSL 2018-04-11T08:04:06Z