topic Re: Rank based table object in QlikView https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659924#M240658 <HTML><HEAD></HEAD><BODY><P>Can you send more info or a file with data?</P></BODY></HTML> Sun, 27 Jul 2014 10:04:21 GMT ecolomer 2014-07-27T10:04:21Z Rank based table object https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659923#M240657 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a detail table in the dashboard with the ranks field and I wanted create another table which should display only Rank 1, another table with Rank 2 another table with Rank 3 etc....up to 10 tables.</P><P></P><P>I tried using all expressions with If Rank=1 then sum() but not getting correct results.</P><P></P><P>Thanks,</P></BODY></HTML> Sun, 27 Jul 2014 10:01:02 GMT https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659923#M240657 2014-07-27T10:01:02Z Re: Rank based table object https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659924#M240658 <HTML><HEAD></HEAD><BODY><P>Can you send more info or a file with data?</P></BODY></HTML> Sun, 27 Jul 2014 10:04:21 GMT https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659924#M240658 ecolomer 2014-07-27T10:04:21Z Re: Re: Rank based table object https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659925#M240659 <HTML><HEAD></HEAD><BODY><P>Pls find the attached sample data which I pulled from table object, and I want show 10 other table objects with their rankings... I&nbsp; marked YELLOW field.</P></BODY></HTML> Sun, 27 Jul 2014 11:46:36 GMT https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659925#M240659 2014-07-27T11:46:36Z Re: Rank based table object https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659926#M240660 <HTML><HEAD></HEAD><BODY><P>Have you tried putting your condition in the dimension and not the expression?</P></BODY></HTML> Sun, 27 Jul 2014 12:07:23 GMT https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659926#M240660 2014-07-27T12:07:23Z Re: Rank based table object https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659927#M240661 <HTML><HEAD></HEAD><BODY><P>Yep, I tried, but no effect</P></BODY></HTML> Sun, 27 Jul 2014 12:12:05 GMT https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659927#M240661 2014-07-27T12:12:05Z Re: Rank based table object https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659928#M240662 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Plz find attached file </P><P>I have created sample QVW application. check your requirement is matching or not.</P><P></P><P><IMG alt="rank table.png" class="jive-image" src="/legacyfs/online/63254_rank table.png" style="width: 620px; height: 302px;" /></P><P></P><P>Regards,</P><P>Vivek</P></BODY></HTML> Mon, 28 Jul 2014 11:15:10 GMT https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659928#M240662 2014-07-28T11:15:10Z Re: Rank based table object https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659929#M240663 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Plz find attached file</P><P>I have created sample QVW application. check your requirement is matching or not.</P><P></P><P><IMG alt="rank table.png" class="jive-image" src="/legacyfs/online/63256_rank table.png" style="width: 620px; height: 302px;" /></P><P></P><P>Regards,</P><P>Vivek</P></BODY></HTML> Mon, 28 Jul 2014 11:15:15 GMT https://community.qlik.com/t5/QlikView/Rank-based-table-object/m-p/659929#M240663 2014-07-28T11:15:15Z