Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Trigger to select values in two fields

Hello,

I have a field that is comprised of two other fields, i.e. Field1/Field2.

I would like for when a value in 'Field1/Field2' is selected, the filters for these individual fields, '%Field1' and '%Field2' are selected.

I can achieve this for one field, using the following

Trigger on [Field1/Field2]

Field = %Field1

Search String = if(count(distinct %Field1) = 1, %Field1)

This works well. I'd like to expand this to include the same logic to select %Field2 if one value is available. Thoughts on how to achieve this?

Thank you

Mel

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Trigger to select values in two fields

Hi Mel,

you can have multiple triggers on the initial field, so you just need to add the same for the second field

Joe

View solution in original post

1 Reply
Highlighted
Not applicable

Re: Trigger to select values in two fields

Hi Mel,

you can have multiple triggers on the initial field, so you just need to add the same for the second field

Joe

View solution in original post