Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted

What if you just do Last_table (without max)

View solution in original post

6 Replies
Highlighted

What if you just do Last_table (without max)

View solution in original post

Highlighted

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

Highlighted
Partner
Partner

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

Highlighted

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

Highlighted
Specialist II
Specialist II

Try this

Table   = Only(Last_table)

Highlighted
Partner
Partner

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