topic Automatic Unselect an item in a List Box in QlikView

Automatic Unselect an item in a List Box

Anonymous — Thu, 26 Jun 2014 17:08:37 GMT

Hello! how do I automatic unslect 3items by using wildmatch function (NON*) in a list box? I tried going to sheet properties and added action select excluded..It works but when i clear all my selections , the select excluded doesnt function anymore. I was thinking of doing the action select in field but just don't know to compose the formula for wildmatch.

Tks.

Re: Automatic Unselect an item in a List Box

vgutkovsky — Thu, 26 Jun 2014 18:24:30 GMT

You need 2 actions. First you need to do a Select in Field of the values that you DON'T want. Then you need a Select Excluded below that first action.

Regards,

Vlad

Re: Automatic Unselect an item in a List Box

Anonymous — Thu, 26 Jun 2014 18:55:45 GMT

Vlad,

The excluded items were grayed out but the values I expectected is wrong.

Tks.

Re: Automatic Unselect an item in a List Box

vgutkovsky — Thu, 26 Jun 2014 19:03:47 GMT

Please post (1) the field name and (2) the values you are selecting in the Select in Field action.

Vlad