Text Object wiht Action

Thu, 29 May 2014 08:58:25 GMT

Hi,

I have a text object with the following Actions:

Select in Field:

Field: Cases

Search String: Open Calls

Select in Field:

Field: logdate

Search String: =minstring({1<[Cases]-={'Closed Calls'} >} [logdate])

Activate Sheet:

Sheet ID: SH02

This takes me to the next sheet and selected all of the Open Calls where the logdate is the earliest in the list so basically it pulls through the oldest date. (Currently shows a case 741 days old)

However if I select a specific department such as Desktop, the Oldest case show the oldest case in that department, but if I then click on the text object, it still pulls through the case that shows 741 days. Is there a way to change this so it shows the oldest case per department when I click on the text object.

Regards,

Jon Ditchfield

Re: Text Object wiht Action

swuehl — Thu, 29 May 2014 10:18:26 GMT

That's probably due to the set identifier 1 you are using in your minstring function.

You can try maybe something like this:

=minstring({1<[Cases]-={'Closed Calls'}, Department = p() >} [logdate])

topic Text Object wiht Action in QlikView

Text Object wiht Action

Re: Text Object wiht Action