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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing particular values in list box

I would like a list box that only show certain values from a particular variabe.

In this example tables 1 and 2 are linked by the item field. If I do a list box on item I get a list of items 1-8, I only want to show 1-4 (based on the "relevent" field in table 2). Is there an expression or am I missing something obvious (probably both)

Table 1

Item
Item 1
Item 2
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8

Table 2

ItemRelevent
Item 11
Item 21
Item 31
Item 41
1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try a field expression (from the field drop selectin list box property) like this:

=if(Relevent, Item)

View solution in original post

2 Replies
swuehl
MVP
MVP

Try a field expression (from the field drop selectin list box property) like this:

=if(Relevent, Item)

Not applicable
Author

Marvellous - thanks!