QlikSense Count If Expression

Qliksenseranelx5 — Sat, 20 Apr 2019 04:51:26 GMT

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

Re: QlikSense Count If Expression

arpitkharkia — Sat, 20 Apr 2019 09:54:39 GMT

Hi,

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

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

and use this flag accordingly.

topic QlikSense Count If Expression in QlikView

QlikSense Count If Expression

Re: QlikSense Count If Expression