Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
brf10043
Creator
Creator

Document Trigger Select in Field on Hierarchy Path

All,  I have a dashboard where I'm trying to set up a document trigger to select the OSUser from the Hierarchy Resource Path column.

My action is a Select in Field with the Field = to Resource Path and the Search String is =right(Lower(OSUser()),len(OSUser())-10)

I lifted the Search String from a different dashboard and it doesn't work here.  How do I set up a Document Trigger to filter the dashboard based on the OSUser being included somewhere in the Hierarchy Resource Path?

The Hierarchy script is below

hier:
Hierarchy (PersonID, ParentID, Mbr_MUD_ID,,Mbr_MUD_ID,[Resource Path],'|',[Resource Depth])

Load
KEYUID as PersonID,
KEYUID as Mbr_MUD_ID,
ZZ_MANAGERUID as ParentID,
ApplyMap('VSED_Mapping',ZZ_MANAGERUID)as Manager_Mbr_MUD_ID
FROM

(
qvd);

0 Replies