Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Object wiht Action

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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])

View solution in original post

1 Reply
swuehl
MVP
MVP

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])