topic Re: Restrict What Shows in List Box in QlikView

Restrict What Shows in List Box

Anonymous — Wed, 12 Nov 2014 09:53:04 GMT

I have 3 types of suppliers (A, B, & C). I have a tab in an application where I only want to see information relating to supplier types A & B which I have done with set analysis. However I have a list box of supplier names which shows all the suppliers regardless of the type. How can I restrict it to show only types A & B?

Thanks

Re: Restrict What Shows in List Box

Anonymous — Wed, 12 Nov 2014 09:59:08 GMT

Hi,

Try this in calculated expression of field in list box:

=if(Supplier<>'C', Supplier)

Marc.

Re: Restrict What Shows in List Box

Anonymous — Wed, 12 Nov 2014 10:03:54 GMT

I've now got 2 columns, one with all suppliers and the other with dashes where the supplier type = C

Re: Re: Restrict What Shows in List Box

ashfaq_haseeb — Wed, 12 Nov 2014 10:08:35 GMT

Hi,

Check this.

Regards

ASHFAQ

Re: Re: Restrict What Shows in List Box

Anonymous — Wed, 12 Nov 2014 10:08:50 GMT

Hi,

Check list boxes and table charts from attached file.

Hope it helps.

Marc.

Re: Restrict What Shows in List Box

Anonymous — Wed, 12 Nov 2014 10:17:12 GMT

This doesn't quite work as I want to restrict the list of [Suppliers] by the field [Supplier Type]

If I use

if ( [Supplier Type] = 'C' , Supplier )

then I still get all the suppliers. Am I missing something?

Thanks

Re: Restrict What Shows in List Box

Anonymous — Wed, 12 Nov 2014 10:17:21 GMT

This doesn't quite work as I want to restrict the list of [Suppliers] by the field [Supplier Type]

If I use

if ( [Supplier Type] = 'C' , Supplier )

then I still get all the suppliers. Am I missing something?

Thanks

Re: Re: Restrict What Shows in List Box

Anonymous — Wed, 12 Nov 2014 10:19:23 GMT

Adian,

Please fins attached in my last post.

Marc.

Re: Restrict What Shows in List Box

ashfaq_haseeb — Wed, 12 Nov 2014 10:20:14 GMT

HI,

Are both of them connected?

If yes then it should work.

Can you post sample data.

Regards

ASHFAQ