topic Re: TRIGGER in QlikView

TRIGGER

adiarnon — Mon, 14 Dec 2015 14:55:33 GMT

hi,

i want that when my user enter the document

one of the fields will filter with the value of the user that entered

so,

i added a trigGer - on open

with selection in field

the field - manager

the value - right(osuser(),7)

its not working!!

and when i added a button

with the same action its working

why???

Re: TRIGGER

jerrysvensson — Mon, 14 Dec 2015 15:20:23 GMT

OnOpen only works if you use Plugin as client.

Using WebView (Ajax) it will not work. See refrence manual.

Re: TRIGGER

rubenmarin — Mon, 14 Dec 2015 15:21:05 GMT

Hi,

- Right(string, 7) will return the last 7 characters (always 7 characters).

- Mid(String, 7) will return the characters from the 7th character of the string (length of result string can vary)

- Subfield(OSUser(), '\', -1) will return the string after the last '\'

Also check that values returned from the 'value' is exactly equal than the field values.

Re: TRIGGER

rubenmarin — Mon, 14 Dec 2015 15:27:32 GMT

If doesn't works because of what Jerry saids and installing plugin to everyone is not an option, maybe you can use section access to filter values on login.

Re: TRIGGER

adiarnon — Mon, 14 Dec 2015 15:32:27 GMT

we are using the Plugin as client.

and like i said

when im using the same action in a button its working!!

Re: TRIGGER

adiarnon — Mon, 14 Dec 2015 15:32:58 GMT

it not the problem

like i said

when im using the same action in a button its working!!

Re: TRIGGER

marcus_sommer — Mon, 14 Dec 2015 15:45:19 GMT

Put osuser() in a textbox to see if it returned what you expect. Further check if both action-expressions are the same and not a typo occured.

- Marcus

Re: TRIGGER

adiarnon — Tue, 15 Dec 2015 13:19:07 GMT

YES,

it returned what im expecting

Re: TRIGGER

marcus_sommer — Tue, 15 Dec 2015 19:23:19 GMT

Try to select anything else maybe something month(today()) or set a variable-value to see if the trigger fired. Another possibility might be to use a landing-page within your app and then using an OnSheetActivate trigger.

- Marcus