topic Filter a Chart Table of Dimensions based on a Field NOT in the Table in App Development

Filter a Chart Table of Dimensions based on a Field NOT in the Table

smarties — Thu, 26 May 2022 08:28:48 GMT

Hi,

I would appreciate some help. I can't see the answer.

I have a sheet with a bunch charts and filters. All works lovely. I want to add a table that lists the records associated with the current state selection (only dimensions, no aggregation, no measures) AND apply an additional selection for the table only (doesn't change the state selection) based on a field that is NOT part of the table (i.e. I don't want the user to see this additional field). This is a permenant additional selection.

I've tried a bunch of things with the Only() function, making one of the fields a Measure, and using Set Analysis. I can't get there.

Any suggestions would be welcome. Thanks.

Re: Filter a Chart Table of Dimensions based on a Field NOT in the Table

vinieme12 — Sat, 28 May 2022 02:42:12 GMT

Use a calculated dimension

=Aggr(only({<OtherDimension={'value1','value2'>} SomeDimension)

Then uncheck Include null values for this dimension

Re: Filter a Chart Table of Dimensions based on a Field NOT in the Table

smarties — Mon, 30 May 2022 19:04:45 GMT

Thanks @vinieme12. Unfortunately, I'm struggling with your suggestion.

I thought the functions Only and Aggr could only be used with a Measure. I've not seen them used with a Dimension.

I get what I want from the QVF attached - using the Only function with set analysis on a Measure. However I get a column I don't want. It's not the end of the world, but it's a column that could cause confusion with users and I want to avoid it.