limit

[sonysree88]

I have a listbox with 30 or so values which I want to limit to 20. This means that only these 20 values should be pre-selected. Is this possible?

[squeakie_pig]

You can use an expression in the listbox field to limit the values to the 20 that you want.

[danansell42]

Hi

A similar question was previously posted on the forums

Limited records in List box

Hope this helps

Dan

[sonysree88]

It will be helpful to get limit of records but the data is less

If we have have huge data how can we limit..

[shree909]

Hi, Create a trigger on opening a sheet. for limiting values on the list box use match function

Select the expression from the drop down of list box and add the below expression.

=if(Match(Field Name,'ABC','Def'),Field Name)

To Pre select these values,on opening the tab, create a  sheet level trigger

1.    Open Sheet properties
2. Select Triggers tab, add action on Activate sheet
3. Add action, select in field,
4. add the field name  and =if(Match(Field Name,'ABC','Def'),Field Name)

[sonysree88]

Hi,

Here you have mentioned like ABC,Def same like i have no of values should limit like upto 40 values how to hide

Its the lengthy process to give the limitation to the listbox

[shree909]

Create a variable As vtest and add values separated by comma and enclosed in single quotes

vtest='ABC','DEF','egh'

Add Expression as

=if(Match([Agent Name],$(vtest)),[Agent Name])

[Anonymous]

share your list box and what you want to limit . That would help us to better assist you

[sonysree88]

Hi ,

Please find the attached QVW here am taking Policyname in listbox..

I want to display only 5 policies how can we do can you please give me the answer with screenshots

We can do this by using match function as previously some guys suggested

But if i have 1 Lac records at that time i want to show only 50000 recorders how can do

It would be appreciate if you can help ASAP

[sonysree88]

Hello,

Can you Please help me on the above Query limitation of listbox