get any select trigger not working

Mon, 24 Feb 2014 03:10:29 GMT

HI,

I want to implement always select one value using trigger. I have put the following expression in the select field

if(GetSelectedCount(CrimeDates) = 0 and GetActiveSheetId()='Document\SH29',max({1}OffenseDateConv),GetFieldSelections(CrimeDates))

What I want is that if there is no selection, then the maximum value of offense date should be picked into the crimedate. However if a selection has been made from the calendar (crimedate), then the selected date should be used.

In the above expression, if I exclude the second condition (GetFieldSelections(CrimeDates)), then on pressing the clear all button, the max offense date is selected in the listbox but if I put the second condition GetFieldSelections(CrimeDates)), the trigger does not work properly. It does not pick the max value on clearing and it does not select multiple values from the listbox. it clears the listbox if I select multiple values

Can someone please tell me whats wrong with the expression

Arif

topic get any select trigger not working in QlikView

get any select trigger not working