Create variable to switch between tables in a collection box using a button

[mauricexyz]

Hello everyone,

regarding the above topic, my idea was to create a variable (e.g. vChangeTable with value 1) and assign this variable to the table within the collection box under "Display condition" in order to then save the created variable in the button with "Action" - "Set variable".

Unfortunately, this does not work. Does anyone have any ideas?

Many thanks in advance

Maurice

Translated with DeepL.com (free version)

[MatheusC]

@mauricexyz 

Please consider this scenario, a container chart with the switch between sheets 0 and 1. Analyze this example:

1 – Variable defined with the initial value,
vChangeTable = 0

2 – Button
Value – 0 (display sheet 1)
Value – 1 (display sheet 2)

3 – Then your container chart, display condition
Fx =$(vChangeTable)=0 or 1 for sheet 2


Regarts, Matheus

[mauricexyz]

Hi Matheus,

Thank you for your reply. I must have made a mistake with my button. I have now deleted and added it. Now it works. But thank you for your tip.

Best regards
Maurice