topic How to filter a dimension-only table? in App Development

How to filter a dimension-only table?

Wed, 29 Jun 2016 17:02:23 GMT

Hi All,

I have a table that will only show two dimensions (title and description), no measures. How can I filter the table to only show a certain type of records? (e.g. I have a table of player positions in various sports and a description of the position. I want to filter out rugby and baseball and only show football)

Thanks in advance!

Re: How to filter a dimension-only table?

karthikoffi27se — Thu, 30 Jun 2016 07:57:24 GMT

Hi Katherine,

You can create a list box and use the option under appearance, check in

Always One Selected Value*

[Define your values that to be listed in the TAB]

Disable the - Show titles

Reduce the size of the table to it's minimum and try to hide it in a corner.

Then add in your dimensions in your straight table. This will be a temporarily solution until conditions is enabled.

Hope this helps

Many Thanks

Karthik

Re: How to filter a dimension-only table?

Thu, 30 Jun 2016 14:01:53 GMT

Thanks Karthik! It's actually even easier than that, the answer was staring me in the face

In the field to enter the dimensions, use an if statement:

=IF( [FieldName] = 'DesiredFieldValue', [FieldName] )

Re: How to filter a dimension-only table?

miguelbraga — Thu, 30 Jun 2016 15:12:13 GMT

Hi Katherine,

Can you post a screenshot of your table?

Did you try to use a set analysis dimension in which you show only your selection from the list box?

Regards,