Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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)
can you share you sample app & expected result ?
Try get possible value function it should work for you .
@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)
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?
I found one solution to mandatory fields here:
https://community.qlik.com/t5/New-to-Qlik-Sense/Adding-Mandatory-Field/td-p/1542630