Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Limit User to select a number of records at least 1 and at most 15.

How to Limit User to select a number of records at least 1 and at most 15.
Company: select one or two permits to 20 companies but does not let me select 21 companies.

1 Reply
Not applicable

using the following statements this will force a selection of at least one if these actions are added to

Settings-->Document Properties-->Field Event Trigger-->[Your Field] --> Edit Action--> Add--> Field

=if( GetSelectedCount([Your Field]) < 1,'Your Field') 

--> Search String

=fieldvalue('Your Field'   ,  FieldIndex('Your Field', Max([Your Field]))) 

This will select the max record #

This will jump to the max record if the user trys to unselect the only selected field selection

It will also select it  if the global clear button is clicked on top of page.

However if you need to unselect the field upon leaving the TAB, you can - add an action to "clear all" upon leaving the tab and it will clear it.

I'm sure you can add another action to limit to 15. I do not know of a way to select 15 however if the user selects 16. however you could select 1 if the user trys to select 16.