Problem setting us document trigger

Anonymous — Wed, 21 Mar 2018 11:07:29 GMT

Hi Geniuses,

I have some tricky trigger problem, let me explain

I have set a trigger select in field ProjectManagerUserName using the function =right(upper(osuser()),(len(osuser())-index(osuser(),'\')))

(it is just taking the windows login and select the field), now I have locked this field...... Now come the tricky part while selecting the second select in field on HierarchyUserName what I want is that first it checks whether HierarchyUserName and windows username are matching if they are matching then clear the previous select in field on ProjectManagerUserName and select the HierarchyUserName

ex Windows login id : sseth

ProjectManagerUserName : sseth

both are matching so now it locks the ProjectManagerUserName with sseth as value

now HierarchyUserName : sseth

as now HierarchyUserName is also sseth so now it should remove the selection on ProjectManagerUserName and lock the selection on HierarchyUserName

Why I am doing it is tricky, may be the data model will tell you, PFA same

topic Problem setting us document trigger in QlikView

Problem setting us document trigger