topic Dynamic measures in App Development

Dynamic measures

Go-Anna — Sat, 16 Nov 2024 18:03:20 GMT

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.

Re: Dynamic measures

agni_gold — Sat, 26 Sep 2020 13:23:26 GMT

can you share you sample app & expected result ?

Try get possible value function it should work for you .

Re: Dynamic measures

Go-Anna — Sat, 26 Sep 2020 15:57:25 GMT

@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-dynamic/m-p/1747404#M172056