Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Jsobrinho77
Creator
Creator

ignore field, only and aggr not working

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) 

Labels (3)
6 Replies
BrunPierre
Partner - Master
Partner - Master

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
Creator
Creator
Author

first of all, thank you for your answer

but the return is: invalid dimension

BrunPierre
Partner - Master
Partner - Master

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
Contributor II
Contributor II

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

Jsobrinho77
Creator
Creator
Author

Using as dimension = return invalid dimension

using as measure = return null

pallavi_96
Partner - Contributor III
Partner - Contributor III

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

pallavi_96_0-1696925760726.png