topic Re: clear other values in a field when one is selected (checkboxes) in QlikView

clear other values in a field when one is selected (checkboxes)

Tue, 29 Dec 2015 15:16:50 GMT

Hi all,

Currently I have a stacked bar chart with expressions that are visible when a user clicks on a field list (inline load). The user clicks in the 'Select Visible Bars' check boxes to display the bar sections they want to see, set up with a conditional show:

IF(GetSelectedCount([~Bar Selector - Conv]) > 0,WildMatch(Concat([~Bar Selector - Conv], '/'), '*Judgment*') > 0, 0)

Currently there is a trigger on sheet activation that checks all options except Judgment as shown below. What I need to happen is when a user clicks on Judgment, it automatically clears the other selections, and when any of the other selections are clicked, Judgment is cleared. I'm assuming you can do this with field event triggers but I haven't been able to figure it out. All help is appreciated, thanks!

Re: clear other values in a field when one is selected (checkboxes)

sunny_talwar — Tue, 29 Dec 2015 16:27:30 GMT

Are you trying to do this?

Re: clear other values in a field when one is selected (checkboxes)

Tue, 29 Dec 2015 16:34:38 GMT

Sunny, I'm not sure what you mean? I tried searching and trial and error for several hours before posting. I was unable to find the answer on my own, most of what I found has to do with selecting one value in a field and using a trigger to automatically select another value in a different field

Re: clear other values in a field when one is selected (checkboxes)

sunny_talwar — Tue, 29 Dec 2015 16:39:38 GMT

I have attached a qvw file, have you looked at the attachment?

Re: clear other values in a field when one is selected (checkboxes)

Tue, 29 Dec 2015 16:56:38 GMT

sorry! I couldn't see the attachment before. I will look at it now, thanks!

Re: clear other values in a field when one is selected (checkboxes)

Tue, 29 Dec 2015 16:58:56 GMT

Sunny, yes that's a start, but I still want to be able to select and deselect the other checkboxes individually. So Judgment can only be by itself, but the others can be selected in any combination (individually or with another selection)

Re: clear other values in a field when one is selected (checkboxes)

sunny_talwar — Tue, 29 Dec 2015 17:04:54 GMT

Try now. This might now work with LED list box, but if you have it the default way and you make selections by pressing CTRL, this seems to be working

Re: clear other values in a field when one is selected (checkboxes)

Tue, 29 Dec 2015 17:17:32 GMT

I need it to work with the checkboxes. when I click c, d clears but if I click d again, it won't change back, it gets stuck on c.

Re: clear other values in a field when one is selected (checkboxes)

sunny_talwar — Tue, 29 Dec 2015 17:58:50 GMT

This is the best I can get. Try it out

Trigger's expression:

=If(GetSelectedCount(Dim) > 0, If((SubStringCount(Concat(DISTINCT Dim, '|'), 'd') = 1 and SubStringCount(Concat(DISTINCT {$1} Dim, '|'), 'd') = 0) or GetFieldSelections(Dim) = 'd', 'd', '("' & Concat(DISTINCT {<Dim -= {'d'}>}Dim, '"|"') & '")'))

Re: clear other values in a field when one is selected (checkboxes)

Tue, 29 Dec 2015 18:19:49 GMT

your example works great but when I try to copy it to my field names it doesn't work correctly. I'm not sure where my error is.

(mine):

=If(GetSelectedCount([~Bar Selector - TC]) > 0,
If((SubStringCount(Concat(DISTINCT [~Bar Selector - TC], '|'), 'Judgment') = 1 and SubStringCount(Concat(DISTINCT {$1} [~Bar Selector - TC], '|'), 'Judgment') = 0) or GetFieldSelections([~Bar Selector - TC]) = 'Judgment', 'Judgment',
'("' & Concat(DISTINCT {<[~Bar Selector - TC] -= {'Judgment'}>}[~Bar Selector - TC], '"|"') & '")'))

where [~Bar Selector - TC] is Dim and 'Judgment' is 'd'

(yours):

=If(GetSelectedCount(Dim) > 0,
If((SubStringCount(Concat(DISTINCT Dim, '|'), 'd') = 1 and SubStringCount(Concat(DISTINCT {$1} Dim, '|'), 'd') = 0) or GetFieldSelections(Dim) = 'd', 'd',
'("' & Concat(DISTINCT {<Dim -= {'d'}>}Dim, '"|"') & '")'))

Re: clear other values in a field when one is selected (checkboxes)

sunny_talwar — Tue, 29 Dec 2015 18:51:26 GMT

Seems to be working here. Did you put the correct field name in the select in field action?

Re: clear other values in a field when one is selected (checkboxes)

Tue, 29 Dec 2015 19:18:32 GMT

I checked, everything is correct. I think there is another trigger or something getting in the way. I am able to select Judgment first, and then when I select something else, Judgment clears. I am also able to select multiple of the other values, but when I go to re-select Judgment, it won't let me unless I clear all the other options first. it works fine on yours but not on mine. I can't post my file for confidentiality reasons. Thank you for your help!!

Re: clear other values in a field when one is selected (checkboxes)

sunny_talwar — Tue, 29 Dec 2015 19:20:29 GMT

Not a problem, I hope you can work with the alternative solution provided by Peter on the other post . If you ever need help again, you can always come back.

Best,

Sunny