Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
_rohitgharat
Creator
Creator

Query

I have a query...

Suppose i have taken a fiscal year field in a list box. If i select more

than 2 selections on fiscal year its should be auto cleared..what logic can

i apply to this???

6 Replies
jagadeesh_diamo
Contributor III
Contributor III

Can you elaborate more?

_rohitgharat
Creator
Creator
Author

For example:

Fiscal years (2011,2012,2013,2014,2015)

If i select 2012, 2013,2014 then selection should be auto cleared it should

allow only 2 selections at a time not more than that.

tresesco
MVP
MVP

If you want users not to allow more than one value to select, you can check for 'Always One Selected Value' option. Select a value in the list box->General tab->enable 'always one selected value'.

_rohitgharat
Creator
Creator
Author

Please reply if there is any solution..

tresesco
MVP
MVP

You can use trigger, like in sample qvw attached.

Clear field trigger:

=If(GetSelectedCount(YourField)>1, 'YourField')

maxgro
MVP
MVP

see attachment

there is a trigger in menù --> settings --> document properties