topic Re: set analysis help in QlikView

set analysis help

Mon, 26 Jan 2026 18:19:17 GMT

I am trying to show the count of a row based on certain criteria. I'm using a text box to show the number.

This is my expression but it does not work, I cant figure out how to do one part of it.

=Count({$<TimeTracker.RequestType={'SR'},{<ServiceDesk.CallRequestNum=TimeTracker.RequestNum>}TimeTracker.ActualCompletedDate)

So I need to count TimeTracker.ActualCompletedDate but only when TimeTracker.RequestType = SR and ServiceDesk.CallRequestNum = TimeTracker.RequestNum.

any help is appreciated

thanks

Alam

Re: set analysis help

Tue, 25 Nov 2014 03:33:16 GMT

Try this one:

count({<TimeTracker.RequestType={SR}>} if(ServiceDesk.CallRequestNum=TimeTracker.RequestNum,TimeTracker.ActualCompleteDate)).

If you want to count the distinct ActualCompleteDate, you need to add 'Distinct' in this expression.

Hope this help you.

Re: set analysis help

jyothish8807 — Tue, 25 Nov 2014 03:39:44 GMT

Hi Alam,

Try like this:

if(time.tracker.requestType='SR' and ServiceDesk.callrequestNum=Timetracker.requestNum,count(Timetracker.actualcompletedate))

Regards

Re: set analysis help

Tue, 25 Nov 2014 05:33:42 GMT

thanks both helped