Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

set analysis help

Hi

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

1 Solution

Accepted Solutions
Not applicable

Re: set analysis help

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.

3 Replies
Not applicable

Re: set analysis help

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.

jyothish8807
Honored Contributor II

Re: set analysis help

Hi Alam,

Try like this:

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

Regards

KC

Best Regards,
KC
Not applicable

Re: set analysis help

thanks both helped

Community Browser