Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP
MVP

Re: Showing particular values in list box

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

=if(Relevent, Item)

2 Replies
MVP
MVP

Re: Showing particular values in list box

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

=if(Relevent, Item)

Not applicable

Re: Showing particular values in list box

Marvellous - thanks!

Community Browser