Hi ShellyG,
If my understanding is correct, you want to give the ability for your users to select which calculation is shown on graph/tables.
PFA sample app.
We have taken an approach in which we have created our "Variables" as a table in the script and then used a combination of pick, match and minstring to display the right calculation when the user makes a selection. After the selection, all graphs/tables with the measure are updated.
To ensure the users make just one selection and it is displaying the right calculation, we have added MinString([Variable]) in our formula and enabled the option to force "always one selection". More detail can be found here: https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/DataSource/select-sing...
//In Script create a table, these are used to add a button or a drop-down that the users can click
Variables:
Load * Inline [Variable
Price
Units
];
//Visualization add as measure:
=pick(match(MinString([Variable]),'Price','Units'),
sum($(vSalesPrice))
,
sum($(vSalesUnits))
)
with
vSalesPrice=([UnitsSold]*Retail)
vSalesUnits=[UnitsSold]
This works for us and our users but i'm sure someone might come with a simple/cleaner version using variables. Please notice this approach might make your visualization load slower.
If you want to display both calculation at same time, then you need something similar to what is discussed on this topic:
https://community.qlik.com/t5/New-to-QlikView/Using-ValueList-with-Pick-Match/td-p/132278
edit: add sample app
Best regards,
Michael
