topic prevent non sequential selection in QlikView

prevent non sequential selection

Fri, 08 Oct 2010 15:02:53 GMT

Hi Guys,

how can i prevent from users to select non sequential selection, for instance

month dim.

1, 4, 12 - wrong

1,2,3 - ok

2 - ok

2,3,4 -ok

Thanks in advanced,

Aviad

prevent non sequential selection

johnw — Fri, 08 Oct 2010 23:28:57 GMT

Attached is one solution. I trigger a macro OnSelect of the field. The maco checks the max and the min, and then makes sure that the count corresponds exactly to that range. If not, then it does an ActiveDocument.Back to undo the offending selection(s).

prevent non sequential selection

Sat, 09 Oct 2010 19:31:34 GMT

Thank u !!!!