Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
New-here1
Contributor III
Contributor III

Count of tickets closed in less than 1 day

Hi,

I want a count of tickets that are closed in less than 1 day. I have tried 'Count(myfield)<1' but I am coming up empty.

The field I am using shows the difference between 2 dates and is in D format. I just want a total of everything that is closed in less that 1.

Can anyone help please?

Thank you

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

You may try this: Count({< myfield = {"<1"}>} myfield)

View solution in original post

2 Replies
marcus_sommer

You may try this: Count({< myfield = {"<1"}>} myfield)

New-here1
Contributor III
Contributor III
Author

Thank you Marcus