Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

Trigger function on selecting field

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

1 Solution

Accepted Solutions
sunny_talwar

What if you just do Last_table (without max)

View solution in original post

6 Replies
sunny_talwar

What if you just do Last_table (without max)

avinashelite

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
Partner - Creator
Partner - Creator
Author

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

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

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Try this

Table   = Only(Last_table)

canmarroig
Partner - Creator
Partner - Creator
Author

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