Limit the number of items in a List Box

[danialier]

Hello,

Do you know how can I limit the number of items in a List Box ?

I mean, I have 5 products (A, B, C, D, E) and two list boxes. I want the first List Box to only show products A, B, C. Then I want the second List Box to only show products C, D, E.

Thks,dani

[alexandros17]

You have to use a sorting or a logic to divide the grups so write in the first listbox:

If(product <= 'C', product, null())

in the second

If(product >= 'D', product, null())

[#3]

Try using something like this in your list box expression:

=if(match(Product,'A','B','C'),Product, null())

[maxgro]

// A B C

=if(match(Product,'A','B','C'),Product)

// not A B

=if(not match(Product,'A','B'),Product)

[MK_QSL]

You can create an Inline Load ...

Load * Inline

[

  Product, Flag

  A, 1

  B, 1

  C, 1

  D, 2

  E, 2

  F, 2

];

Now Use

IF(Flag = 1, Product)

IF(Flag = 2, Product)

[nagaiank · Accepted solution]

A solution is attached

[danialier]

excellent !!! many thanks for the attachment !

[aveeeeeee7en]

Hi Dani

See the Attached.

[danialier]

I really like that approach ! Thanks !