Toggle creation for all valueas in a field

[Peony]

Hi all

A tried to create a toggle that will perform switch between values in a field "Category". Currently field contains two values ​​Cat_A and Cat_B(in future there coud be more categories).
The difficulty is that this switch should allows to choose between Cat_A, Cat_B and All(it shoud select Cat_A and Cat_B together). And I don't understand how coud I create this category "All" without concatenating values, because concatenate load doubles existing data.

Could someone give me a hint regarding this issue?

[Vegar · Accepted solution]

You could add a dim-table to your app where "all" is associated with both values.

Data:

Load * From Source; // this data includes the Category field

Toogle:

Load * inline [

Category_toogle, Category

Cat_A, Cat_A

Cat_B,Cat_B

All, Cat_A

All, Cat_B

];

[Peony]

@Vegar thank you much!

[seanbruton]

Superb, very helpful solution!!!