topic Filtering numbers in App Development https://community.qlik.com/t5/App-Development/Filtering-numbers/m-p/1559957#M40785 <P>Hello, I need some help on filtering numbers. So. I have a data column consists of manhours. It has a condition that manhours couldn't more than 8 hours and less than 0 hours (I mean negative number like -1 which is irrational in numbers). I would like to filter this column so then I could show the data that has value more than 8 hours and less than 0 hour, so I could trace the one who submitted those data. what expression could I use to do this? thank you</P> Fri, 22 Mar 2019 08:37:39 GMT nsigitsutanto 2019-03-22T08:37:39Z Filtering numbers https://community.qlik.com/t5/App-Development/Filtering-numbers/m-p/1559957#M40785 <P>Hello, I need some help on filtering numbers. So. I have a data column consists of manhours. It has a condition that manhours couldn't more than 8 hours and less than 0 hours (I mean negative number like -1 which is irrational in numbers). I would like to filter this column so then I could show the data that has value more than 8 hours and less than 0 hour, so I could trace the one who submitted those data. what expression could I use to do this? thank you</P> Fri, 22 Mar 2019 08:37:39 GMT https://community.qlik.com/t5/App-Development/Filtering-numbers/m-p/1559957#M40785 nsigitsutanto 2019-03-22T08:37:39Z Re: Filtering numbers https://community.qlik.com/t5/App-Development/Filtering-numbers/m-p/1559975#M40789 how do you calculate manhours?<BR />where do you want to implement that logic in back end or in front end??<BR /><BR />Regards,<BR />Prashant Sangle Fri, 22 Mar 2019 09:28:54 GMT https://community.qlik.com/t5/App-Development/Filtering-numbers/m-p/1559975#M40789 PrashantSangle 2019-03-22T09:28:54Z Re: Filtering numbers https://community.qlik.com/t5/App-Development/Filtering-numbers/m-p/1560325#M40821 The manhours were provided by excel file which I used in qliksense. I would like to show the number of wrong submitted manhours in the dashboard. So, it is in the front end, right? Sat, 23 Mar 2019 03:12:10 GMT https://community.qlik.com/t5/App-Development/Filtering-numbers/m-p/1560325#M40821 nsigitsutanto 2019-03-23T03:12:10Z