https://community.qlik.com/t5/QlikView/how-to-display-bottom-N-values-including-0-values-using-Rank/m-p/1769366#M454507 <P>Hi Guys&nbsp;</P><P>I want to display bottom N values including 0 values in a straight table having 2 dimensions and 1 Expression.</P><P>I am attaching a sample qvw file.&nbsp;</P><P>When i am trying to show bottom 5 , i am getting below output&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Team</TD><TD>Office</TD><TD>&nbsp;</TD></TR><TR><TD>A</TD><TD>O1</TD><TD>-100</TD></TR><TR><TD>E</TD><TD>O5</TD><TD>-50</TD></TR><TR><TD>F</TD><TD>O6</TD><TD>-40</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Output:</P><TABLE border="1"><TBODY><TR><TD>Team</TD><TD>Office</TD><TD>&nbsp;</TD></TR><TR><TD>A</TD><TD>O1</TD><TD>-100</TD></TR><TR><TD>E</TD><TD>O5</TD><TD>-50</TD></TR><TR><TD>F</TD><TD>O6</TD><TD>-40</TD></TR><TR><TD>B</TD><TD>O2</TD><TD>0</TD></TR><TR><TD>C</TD><TD>O3</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please let me know what i am doing wrong.</P><P>&nbsp;</P><P>Thanks in advance.</P> Thu, 17 Dec 2020 23:40:54 GMT Manish 2020-12-17T23:40:54Z https://community.qlik.com/t5/QlikView/how-to-display-bottom-N-values-including-0-values-using-Rank/m-p/1769366#M454507 <P>Hi Guys&nbsp;</P><P>I want to display bottom N values including 0 values in a straight table having 2 dimensions and 1 Expression.</P><P>I am attaching a sample qvw file.&nbsp;</P><P>When i am trying to show bottom 5 , i am getting below output&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Team</TD><TD>Office</TD><TD>&nbsp;</TD></TR><TR><TD>A</TD><TD>O1</TD><TD>-100</TD></TR><TR><TD>E</TD><TD>O5</TD><TD>-50</TD></TR><TR><TD>F</TD><TD>O6</TD><TD>-40</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Output:</P><TABLE border="1"><TBODY><TR><TD>Team</TD><TD>Office</TD><TD>&nbsp;</TD></TR><TR><TD>A</TD><TD>O1</TD><TD>-100</TD></TR><TR><TD>E</TD><TD>O5</TD><TD>-50</TD></TR><TR><TD>F</TD><TD>O6</TD><TD>-40</TD></TR><TR><TD>B</TD><TD>O2</TD><TD>0</TD></TR><TR><TD>C</TD><TD>O3</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please let me know what i am doing wrong.</P><P>&nbsp;</P><P>Thanks in advance.</P> Thu, 17 Dec 2020 23:40:54 GMT https://community.qlik.com/t5/QlikView/how-to-display-bottom-N-values-including-0-values-using-Rank/m-p/1769366#M454507 Manish 2020-12-17T23:40:54Z https://community.qlik.com/t5/QlikView/how-to-display-bottom-N-values-including-0-values-using-Rank/m-p/1769373#M454508 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/77128">@Manish</a>&nbsp;</P><P>PFA</P> Fri, 18 Dec 2020 02:39:25 GMT https://community.qlik.com/t5/QlikView/how-to-display-bottom-N-values-including-0-values-using-Rank/m-p/1769373#M454508 MayilVahanan 2020-12-18T02:39:25Z