Is there a way using the expression syntax to make the the criteraia AND the condition dynamic when linking to a filter view. For instance I am trying to write and expression like the follwing
LINKTOFILTEREDVIEW("Drilled Down", ([_THISROW].[criteria] = [_THISROW].[condition])) where criteria and condition are both strings from my database, however this does not work presumably because it resolves to something unexpected.
LINKTOFILTEREDVIEW("Drilled Down", ([Customer Name] = [_THISROW].[condition])) works just fine but I'm trying to link to the drilled down view and filter based on a different criteria per row.
like LINKTOFILTEREDVIEW("Drilled Down", (Customer Name = "tom")) rather than
LINKTOFILTEREDVIEW("Drilled Down", ([Customer Name] = "tom")) it almost as if there needs to be an EVAL syntax within the expression to accommodate for scanrios such as this.
I don't understand what you're asking. If you're asking whether AppSheet has a function comparable to the INDIRECT function in spreadsheet apps, the answer is no.
Essentially I'm just asking if there is a way to populate the entire filter criteria from the information in the row both the condition ( first part ) and the criteria ( second part ). Typically you might write the filter portion as follows
([Customer Name] = [_THISROW].[condition]))
but I want to be able to swap out [Customer Name] with [Venue Name] or something else on the fly from info in [_THISROW]
Likely, you need to use a perhaps dense expression to account for all possible scenarios via an IFS or, as in the following example, SWITCH function:
LINKTOFILTEREDVIEW(
"Drilled Down",
SWITCH(
[SelectedColumn],
"Customer Name", [Customer Name],
"Venue Name", [Venue Name],
...
) =
[_THISROW].[condition]
)
The expression is fixed; there is no EVAL equivalent. @dbaum's suggestion is a valid alternative.
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |