In simple terms, on my 'home' tab, I want users to select from one of two list boxes :
[Data Number] or
For subsequent sheets, I am utilizing function : GetFieldSelections(<field>)
As I am offering the user 2 fields to select from, I am having to constantly reference both fields, which leads to lots of if/and/or/but scenarios - complicating set analysis much more than it needs to be.
So, I am looking for a way to consolidate the users selections back into 1 field.
Example (using table below) :
If a user selects [Date number] 2, then both [Date Value] '02/01/2017' AND '13/02/2017' need to become 'Selected'
I am thinking that this can be done via triggers, but not quite worked out the method as of yet !
If you load your table as a logical table in Qlik rather than a se of disconnected fields, there is nothing special needed. When you select Date Number = 2, the corresponding values of the Date Value become "possible" (indirectly selected,if you wish). (Not clear from your description why you need GetFieldSelections(), if you have a reasonable data model.)