Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Object with calculated action

Hi Again

Would someone be able to help me on the following query please?

I have the following text objects which does a count of the Oldest case on the system on the field logdate:


=num($(vTODAYS_DATE)-(MinString({$<status_name ={'Unaccepted','Unassigned','Pending','Off Hold','On Hold'} >} [logdate])), '#,##0')

What I want to do is create another Text Object under that with an action that takes me to SH02 and finds the case on a Straight Chart that only pulls through the case with the oldest case.

Regards,

Jon Ditchfield

1 Reply
marcus_sommer

This could work if you put the (calculated) sheet and the case in additionally variables and the click-action on the textbox used these variable-values to switch the sheet and select any values and/or set the visibilty for an object on true or false.

- Marcus