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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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