Thanks master!
And a new cool thing that I discovered with this technic, is that we can apply it on Charts, to build a dynamic chart with just 1 choice component + 1 chart.
Updated simplified approach if the inline list (or graph) data to display are in the same tab than the User Specific data selected via Choice component.
OBJECTIVE
Display an inline list according to the selection of a choice component (ex. gender) AND grouped by the categories of this selection (ex.woman, man)
SOLUTION
In the dataeditor:
- “User specific” field: hosting the choice component selection
- “Single Value” field (select ‘First’): linked to the “User Specific” field
- “IF” field: with “If Single Value is (‘choice option 1’ entered manually), then (column related to this option), idem for option 2, 3…”
NB: if the words of the source values of the Choice component are changed, they must also be changed in the “IF” field.