Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

Re: Text Object wiht Action

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

1 Reply
MVP
MVP

Re: Text Object wiht Action

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

Community Browser