ignore field, only and aggr not working

[Jsobrinho77]

Hi guys,

I have the field1 and field2

Example:

Field1, field2

A,BB

A,CC

A,-

and I'm trying to do a filter to field1 ignoring any selection by field2, but is not working.

is the problem null, third line,?

How can I ignore filter2 and show all values from field1

aggr(only({<field2>} field1),field1) 

[BrunPierre]

I'd use the following expression to retain selections in 'field1' and 'field3' while disregarding selections in all other fields.

Only({1<field1=$::field1, field3=$::field3>} field1)

[Jsobrinho77]

first of all, thank you for your answer

but the return is: invalid dimension

[BrunPierre]

I'd use the following expression to retain selections in 'field1' and 'field3' while disregarding selections in all other fields.

Only({1<field1=$::field1, field3=$::field3>} field1)

[pallavsi_08]

Use Only({1<Field1=$::Field1>} Field1) as a measure not a dimension. It will work

[Jsobrinho77]

Using as dimension = return invalid dimension

using as measure = return null

[pallavi_96]

Only({1<Field1=$::Field1>} Field1) as a measure works for me