topic Re: Selection in month is cleared with clear button for individual list box in QlikView

Selection in month is cleared with clear button for individual list box

Thu, 14 May 2015 10:40:02 GMT

Hi Everyone,

I have created a trigger on the month field and monthnum field. That if i select a month example APR the all the months from JAN to APR are selected.

='('&Concat({<Month,MonthNum={"<=$(=MonthNum)"}>}Month,'|')&')'

But when i use the clear field of a list box along with the list box of that particular field the field month also gets cleared.

I want the selection in the field month to be constant if i use any of the clear field on the list boxes.

Thanks in advance.

Regards,

Akshay

Re: Selection in month is cleared with clear button for individual list box

awhitfield — Thu, 14 May 2015 10:45:46 GMT

Hi Akshay,

you could try:

Select 1 item in you list box, select properties and then tick 'Always One Selected Value'

HTH Andy

Re: Selection in month is cleared with clear button for individual list box

stigchel — Thu, 14 May 2015 10:51:37 GMT

You could look at locking the field, but In general I would suggest not to rely on a listbox having several selections, but move that logic to your calculations with the help of set analysis e.g.

Sum({<Month,MonthNum={"<=$(=Max(MonthNum))"}>} Sales)