Get the values of an enum list of a table into a virtual column (ref) of another table

AppSheet AppSheet Q&A
1

Hello everyone,

I am currently struggling with the following idea:

In a detail view to a table A I have a chart, which is a virtual column of a related view to a slice.
In this chart I want to appear the values of this row of table A and some other values of some rows that should come from a separate filter table .

In the column view the virtual column related chart has the type: list; element type: ref.

If I just type in:

LIST(
[_THISROW].[ID_Project],
1,
2,
3
)

So it kind of shows what I theoretically need to have. But in fact I want the numbers 1, 2, 3 be dynamic and come out of a enum list of row 1 of the filter table (ChartButtons).

So what I have tried is:

list(
concatenate(
[_THISROW].[ID_Table_A],
" , ",
Split(
LOOKUP(
“1”,
“ChartButtons”,
“ID_ChartButton”,
“ButtonFilter”
)
),
" , "
)
)

Currently it works not quite fine. The this.row value of table a is showing in the chart. And the first (of the three values of the list is being shown. But both of the 3 others inside the enum list of the filter table are not shown.

How can I make the other values of the enum list show and combine them with values of this.row of table A?

Thank you!

2

Just in terms of expression, I believe your expression needs to be something like below

LIST([_THISROW].[ID_Table_A]) + SPLIT(SELECT(ChartButtons[ButtonFilter], [ID_ChartButton]=1),“,”)

2 Likes
3

Suvrutt_Gurjar:

LIST([_THISROW].[ID_Table_A]) + SPLIT(SELECT(ChartButtons[ButtonFilter], [ID_ChartButton]=1),“,”)

that works perfect. Thank you Suvrutt!

2 Likes