Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
datagrrl
Creator III
Creator III

When using an expression as list box, field with values used as condition has those values selected

I have a conditional list box:

=if(Field1<10,Field2)

If I select values from this list box, the field with the conditional is also selected.

 

For example, if I select 31, for field 2, 2,3,5 are selected in Field1

datagrrl_0-1598627305108.png

But 31 in field 2 has more matches and I want to see all of those:

datagrrl_1-1598627371981.png

 

I read a post that implies I might be able to do this with set analysis, but I am struggling to write the set analysis.

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Actually try this instead

 

=Aggr(Only({<Field1 = {"<10"}, Field2>} Field2), Field2)

 

View solution in original post

3 Replies
sunny_talwar

Try this

Aggr(Only({<Field1 = {"<10"}>} Field2), Field2)
sunny_talwar

Actually try this instead

 

=Aggr(Only({<Field1 = {"<10"}, Field2>} Field2), Field2)

 

datagrrl
Creator III
Creator III
Author

Thanks, I was missing the Aggr part, that makes sense.