topic Filtering the Records in QlikView https://community.qlik.com/t5/QlikView/Filtering-the-Records/m-p/226945#M79100 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a straight table with the following records.</P><P>Sr No Value</P><P>1 30</P><P>2 50</P><P>3 40</P><P>4 20</P><P>5 10</P><P>6 24</P><P>The Value field (Made some calculation in the straight table using some other fields).</P><P>I want only 4 records out of 6. Can any guide me.</P><P>Thanks,</P></BODY></HTML> Mon, 04 Oct 2010 12:35:44 GMT 2010-10-04T12:35:44Z Filtering the Records https://community.qlik.com/t5/QlikView/Filtering-the-Records/m-p/226945#M79100 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a straight table with the following records.</P><P>Sr No Value</P><P>1 30</P><P>2 50</P><P>3 40</P><P>4 20</P><P>5 10</P><P>6 24</P><P>The Value field (Made some calculation in the straight table using some other fields).</P><P>I want only 4 records out of 6. Can any guide me.</P><P>Thanks,</P></BODY></HTML> Mon, 04 Oct 2010 12:35:44 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Records/m-p/226945#M79100 2010-10-04T12:35:44Z Filtering the Records https://community.qlik.com/t5/QlikView/Filtering-the-Records/m-p/226946#M79101 <HTML><HEAD></HEAD><BODY><P>Hi tims,</P><P></P><P>Try this in your dimension.... (your_Expression is nothing but your calculation)</P><P></P><P>=aggr(if(rank(total your_Expression)&lt;=4,[Sr No],'Other'), ,[Sr No])</P><P></P><P>Revert back if any queries</P><P>Ren</P></BODY></HTML> Mon, 04 Oct 2010 12:57:36 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Records/m-p/226946#M79101 renjithpl 2010-10-04T12:57:36Z