Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
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

1 Reply
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