topic Re: Showing particular values in list box in QlikView

Showing particular values in list box

Wed, 22 Aug 2012 08:40:33 GMT

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

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

Table 2

Item	Relevent
Item 1	1
Item 2	1
Item 3	1
Item 4	1

Re: Showing particular values in list box

swuehl — Wed, 22 Aug 2012 08:43:58 GMT

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

=if(Relevent, Item)

Re: Showing particular values in list box

Wed, 22 Aug 2012 08:55:49 GMT

Marvellous - thanks!

topic Re: Showing particular values in list box in QlikView

Showing particular values in list box

Table 1

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

Table 2

Re: Showing particular values in list box

Re: Showing particular values in list box

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