topic Select / Lock / Deselect in QlikView

Select / Lock / Deselect

Anonymous — Thu, 14 Oct 2010 16:29:39 GMT

I have a button which pre-selects 5 of a total possible 100 values & locks it down. However, this prevents my user to further select any one of the five. Then I removed the lock, which enables the user to further restrict. However, when the user deselects that field, it now shows all the 100 values. How do I restrict in such a way that at any point in time, the users sees only 5 values? Please note that I am not looking to for section access restriction or removing rows in the load script. Maybe a macro? Or am I over-complicating?

Thanks,

Dinesh.

Select / Lock / Deselect

Thu, 14 Oct 2010 16:42:10 GMT

If the selection comes only in a list box, you can add an expression to the list box in order to display only the disired values, like this:

=if(match([Field], 'Val1','Val2',...,'Val5'), [Field])

Regards

Select / Lock / Deselect

Thu, 14 Oct 2010 16:54:44 GMT

Dinesh,

I think you need to do this in script. Aloop of 5 from prvious loaded field. I have attached a qvw file. Check if it works for you, In loop you can do some more work like values that are started with A or length = 5 etc...