topic how do i limit rows in a dataset in QlikView https://community.qlik.com/t5/QlikView/how-do-i-limit-rows-in-a-dataset/m-p/1374030#M818347 <HTML><HEAD></HEAD><BODY><P>Hi, I'm new using QLik. I added a dataset from ODBC.&nbsp; But I want to use a column to limit the data in the graph.&nbsp; e.g I want to sum(fees) but on if the company is of a certain size.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z how do i limit rows in a dataset https://community.qlik.com/t5/QlikView/how-do-i-limit-rows-in-a-dataset/m-p/1374030#M818347 <HTML><HEAD></HEAD><BODY><P>Hi, I'm new using QLik. I added a dataset from ODBC.&nbsp; But I want to use a column to limit the data in the graph.&nbsp; e.g I want to sum(fees) but on if the company is of a certain size.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-do-i-limit-rows-in-a-dataset/m-p/1374030#M818347 2020-11-25T16:16:04Z Re: how do i limit rows in a dataset https://community.qlik.com/t5/QlikView/how-do-i-limit-rows-in-a-dataset/m-p/1374031#M818348 <HTML><HEAD></HEAD><BODY><P>you can create a new column or field in the script based on your logic for company size and then you can use it in the front end as a filter to limit the results in the chart.</P></BODY></HTML> Wed, 23 Aug 2017 17:54:43 GMT https://community.qlik.com/t5/QlikView/how-do-i-limit-rows-in-a-dataset/m-p/1374031#M818348 sudeepkm 2017-08-23T17:54:43Z Re: how do i limit rows in a dataset https://community.qlik.com/t5/QlikView/how-do-i-limit-rows-in-a-dataset/m-p/1374032#M818349 <HTML><HEAD></HEAD><BODY><P>Can you share your column and script.</P></BODY></HTML> Wed, 23 Aug 2017 17:59:43 GMT https://community.qlik.com/t5/QlikView/how-do-i-limit-rows-in-a-dataset/m-p/1374032#M818349 its_anandrjs 2017-08-23T17:59:43Z