Docuement Trigger Select in Field on Hierarchy Resource Path

brf10043 — Wed, 25 Nov 2020 16:16:04 GMT

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

topic Docuement Trigger Select in Field on Hierarchy Resource Path in QlikView

Docuement Trigger Select in Field on Hierarchy Resource Path