Using a "switch" cell to enable easy analysis on different scenarios

5.78K viewsTips and Techniques

Recently I was asked if there is a method in Quantrix to save the configuration of a set of variables, then select the configuration from a list allowing mutliple scenario analysis. I’m posting the answer here in case anyone else finds it useful.

This kind of scenario analysis can be done by using a “switch” cell in a Matrix to dictate the values passed into a model.

A “switch” can be created in a cell by using the ‘Constrain Input’ list functionality [color=”DimGray”](Right click on cell > Constrain Input > List)[/color]. The value selected from this list can then be used in an [b:ii9ud2tf]IF [/b:ii9ud2tf]statement, to dictate the values passed into the model.

I have attached an example model that shows the use of a Scenario Switch. In the example model, the Scenario Switch controls the Rate Value that is passed into the Income Growth Results table. :cool:


TX Ranger,

When you use the scenarios in the dimension then you can either show them all in a matrix or move the Scenario Type up to the filter pane to select just one scenario.

You can check this in the attached model (Model Browser -> Folder “Version 2”).


You are viewing 1 out of 5 answers, click here to view all answers.

Latest Questions