Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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