Dynamic measures

[Go-Anna]

Hi!

I have, at the moment, 3 measures Actual 2020, Budget 2020 and Budget 2021. In the future I will add years. I want to be able to use these different Actuals and Budgets in my reports interchangeably. 

So I have made 3 tables called M1, M2 and M3 where I have added all three measures in each. So the idea is for the user to be able to choose M1, M2 or M3 as defined in the table.

I tried to use "Getfield selections" as a variable, but that didn't work. Then I tried =concat( distinct M1formel , ', '), and that resulted in that the right formula is shown in the cells but I need the cells to USE the formula, not just show it!! 

I enclose 3 screenshots, first my M1 table, secondly the results from concat and thirdly the expected results. Thanks.

[agni_gold]

can you share you sample app & expected result ?

Try get possible value function it should work for you .

[Go-Anna]

@Kushal_Chawda solved the problem:

try  below expression. But note that all expressions can't be evaluated at the same time based on selection individual expression will be evaluated

=$(=M1formel)

Thank you @Kushal_Chawda 

I have posted my next problem regarding setting a default or making it mandatory to choose a value here:

https://community.qlik.com/t5/New-to-Qlik-Sense/Get-a-selection-and-use-the-formula-in-order-to-make...