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: 
Qliksenseranelx5
Contributor III
Contributor III

QlikSense Count If Expression

Hi all I need help with a count if expression. I’m creating a dashboard for help desk incident tickets to show how long it took to close the ticket. I’ll have 5 different columns for different timeframes but once I get one expression working I can replicate the others. I’m trying to count the number of incidents that took 24 hours or more to close. I have a time to close calculated field formatted “hh:mm”. If the incident didn’t close in 24 or more hours I want it to be blank showing nothing. Here is what I have that’s not working:  count(if([timetoclose]>=‘24’),distinct [incidentID],[“”]) 

please help

1 Solution

Accepted Solutions
arpitkharkia
Creator III
Creator III

Hi,

You can create a flag-column in the back end like

if(timeField>time(1),1,0)

and use this flag accordingly.

View solution in original post

1 Reply
arpitkharkia
Creator III
Creator III

Hi,

You can create a flag-column in the back end like

if(timeField>time(1),1,0)

and use this flag accordingly.