topic Re: Trigger function on selecting field in QlikView

Trigger function on selecting field

canmarroig — Fri, 22 Apr 2016 09:46:36 GMT

Hi, i've a a question, 2 fields:

[Table] with a list of value 1, 2, 10, 20

[Last_table] with only one value 1 or 2 or 10 or 20

opening my qwv i want to get a selection: Table = Last_table

I don't understand why my trigger function

Table =max({1}Last_table)

is wrong, what can I do.

Tks

sunny_talwar — Fri, 22 Apr 2016 09:49:03 GMT

What if you just do Last_table (without max)

avinashelite — Fri, 22 Apr 2016 09:49:53 GMT

have you used the on open trigger or field event trigger ??

create a on open trigger and try you expression this should work , check the field names once

canmarroig — Fri, 22 Apr 2016 10:24:21 GMT

I don't understand: i've applied the same function as suggested by Sunny:

select in a field -> Table =Last_table

1) on a button action: it's correct

2) on a open document trigger: it doesn't run

Why

sunny_talwar — Fri, 22 Apr 2016 10:28:21 GMT

Would you be able to share a sample showing it isn't working?

Joaquin_Lazaro — Fri, 22 Apr 2016 10:50:30 GMT

Try this

Table = Only(Last_table)

canmarroig — Fri, 22 Apr 2016 12:26:22 GMT

There's another action: selecting one sheet, I have to keep this after table selection not before.