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
how do you calculate manhours? where do you want to implement that logic in back end or in front end??
Regards, Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
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?
