Discussion Board for collaboration related to QlikView App Development.
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?
Go to Solution.
you can have multiple triggers on the initial field, so you just need to add the same for the second field