Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Jsobrinho77
Creator
Creator

aggr and only show all rows in the filter

Hi guys,

I have a filter, that I'm using only and aggr, but when I select 1 value, another option shows gray, the correct one shows white right? i.e. other options are possible to filter ( white background, not gray)

my expression:

aggr( only({1<field1={*}, fieldtype={1}>} field1),field1)

I already tried:
aggr( nodistinct only({1<field1={*}, fieldtype={1}>} field1),field1)

But another option shows gray background

Labels (3)
1 Reply
Chanty4u
MVP
MVP

try this

aggr(only({1<field1={*}, fieldtype={1}>} total field1), field1)