4 Replies Latest reply: Apr 15, 2015 6:24 PM by Aaron Kelly RSS

    Need to count where a field is greater than a specific time

    Aaron Kelly

      I have data in a table field that is stored as a time value in the format h:mm:ss. I need to do a comparison and make show what percentage of the data in that column is greater than 0:01:20. The values in this field range anywhere from 0:00:01 to almost 0:20:00. I just started using Qlik Sense yesterday. I can do some basic things such as an average of ALL the data in that table but I need to be able to look at only a subset of it as well. All help appreciated. Following is what I'm trying to achieve but doesn't work: Count(Turnout > 0:01:20)