Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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)

 

View solution in original post

datagrrl
Creator III
Creator III
Author

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