Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Go-Anna
Contributor III
Contributor III

Get a selection and use the formula in order to make dynamic measures

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 show it!! Anybody?

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

 

Labels (4)
1 Solution

Accepted Solutions
Kushal_Chawda

@Go-Anna  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)

View solution in original post

4 Replies
agni_gold
Specialist III
Specialist III

can you share you sample app & expected result ?

Try get possible value function it should work for you .

Kushal_Chawda

@Go-Anna  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)

Go-Anna
Contributor III
Contributor III
Author

YES!!! Thank you! That worked perfectly! Fantastic!

So, my next questions are....

1-can I make a default value, ie if nothing in my M1 table is selected, so that a default value is then shown

2-can I somehow make it necessary to choose an M1  option when going to the report?

Go-Anna
Contributor III
Contributor III
Author