topic Re: Rank using dimension not shown in chart in QlikView https://community.qlik.com/t5/QlikView/Rank-using-dimension-not-shown-in-chart/m-p/100847#M759572 <HTML><HEAD></HEAD><BODY><P>Did you get a chance to look at my response here</P><P><A href="https://community.qlik.com/thread/311455">Rank of dimension not used in chart</A></P></BODY></HTML> Mon, 20 Aug 2018 16:21:08 GMT sunny_talwar 2018-08-20T16:21:08Z Rank using dimension not shown in chart https://community.qlik.com/t5/QlikView/Rank-using-dimension-not-shown-in-chart/m-p/100846#M759571 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table of data:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Category 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Category 2</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A-1</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A-2</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A-3</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">B-1</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">B-2</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-1</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-2</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-3</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-3</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-4</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to add the field based on the rank of the count of category 1, such that:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; border-image: none; width: 100%;"><TBODY><TR><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>Category 1</STRONG></TH><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>Category 2</STRONG></TH><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>New field</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A-1</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A-2</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A-3</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">B-1</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">B-2</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-2</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-3</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-3</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C-4</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>Based on the new field, I want to create a chart which only shows the count of category 2 where the value of new field is 1.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Category 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Count(Category 2)</STRONG></TH></TR><TR><TD style="padding: 2px;">C-1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">C-2</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">C-3</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">C-4</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>Could anyone give me some clue how to do it? Thanks a lot!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Rank-using-dimension-not-shown-in-chart/m-p/100846#M759571 Anonymous 2020-11-25T16:16:04Z Re: Rank using dimension not shown in chart https://community.qlik.com/t5/QlikView/Rank-using-dimension-not-shown-in-chart/m-p/100847#M759572 <HTML><HEAD></HEAD><BODY><P>Did you get a chance to look at my response here</P><P><A href="https://community.qlik.com/thread/311455">Rank of dimension not used in chart</A></P></BODY></HTML> Mon, 20 Aug 2018 16:21:08 GMT https://community.qlik.com/t5/QlikView/Rank-using-dimension-not-shown-in-chart/m-p/100847#M759572 sunny_talwar 2018-08-20T16:21:08Z