topic Re: Button to exclude multiple items from field in QlikView

remove multiple items from field

userid128223 — Fri, 22 Sep 2017 19:30:08 GMT

I have table like below.

Student

John

Cline

Viennesa

Ivan

Mike

I want to create a button to exclude John & Mike from selection once Button is pressed. How can i achieve this.

Thanks

Re: Button to exclude multiple items from field

vishsaggi — Fri, 22 Sep 2017 19:37:40 GMT

What should happen when you clear selections? Does all the names should show? Where these values should be displayed in a Listbox? Or in a chart? If list box then go to List box properties then check the box Hide Excluded.

Then create a button with action as Select in Field then give Student as field and string as

= '(' & Concat({< Student -= {'John', 'Mike'} >}Student, '|') & ')'

Re: Button to exclude multiple items from field

userid128223 — Fri, 22 Sep 2017 19:41:31 GMT

I don't want to just hide the name but instead want to remove them from selection for all the charts & list box.

i have button that selects multiple value for one field. In the same button i wanted to now exclude multiple value for 1 field.

Re: Button to exclude multiple items from field

vishsaggi — Fri, 22 Sep 2017 19:44:22 GMT

Try to use that Set statement in your button. Can you share the expression you are using for the button you have?

{< Student -= {'John', 'Mike'} >}

Can you share a sample you are working on?

Re: Button to exclude multiple items from field

userid128223 — Fri, 22 Sep 2017 20:08:21 GMT

Attached is example. I have Button1 which selects Student Cline, Ivan & Mike.

Below is what i want to do.

1) Exclude Teacher = Allen

2) Select Mike, Ivan & Cline

Both using same button.

Final Result: Cline & Ivan will be highlighted. As Mike has Allen as teacher.

Re: Button to exclude multiple items from field

vishsaggi — Fri, 22 Sep 2017 20:18:19 GMT

Allen has a student Ivan so when teacher Allen is excluded his student Ivan is excluded so only Mike and Cline will be selected. Is it not. ?

Re: Button to exclude multiple items from field

userid128223 — Fri, 22 Sep 2017 20:21:03 GMT

Yes

Re: Button to exclude multiple items from field

vishsaggi — Fri, 22 Sep 2017 20:21:16 GMT

use this as your search string and see.

= '(' & Concat({< Student = {'Cline', 'Mike', 'Ivan'}> - <Teacher = {'Allen'}>} Student, '|') & ')'

Re: Button to exclude multiple items from field

userid128223 — Fri, 22 Sep 2017 20:27:59 GMT

when you select Teacher Allen and select excluded it shows up in your Current selection box. How do you see the same results when you are doing via button

Re: Button to exclude multiple items from field

vishsaggi — Fri, 22 Sep 2017 20:31:00 GMT

Did not get you. Can you send me a screen shot of what you are expecting?

Re: Button to exclude multiple items from field

vishsaggi — Fri, 22 Sep 2017 20:37:20 GMT

Oops ok Got it. You want to see who are the possible Teachers for the selected student when button is clicked.

Just add another action Select Possible and add field Teacher. Like below?

Re: Button to exclude multiple items from field

userid128223 — Fri, 22 Sep 2017 20:47:09 GMT

For some reason my in field selection for my actual project is not working. But i tried on my example project and it works fine.

Could it be because the search filed might have spaces.

Re: Button to exclude multiple items from field

vishsaggi — Fri, 22 Sep 2017 20:50:09 GMT

Could be possible. So use like trim(yourfieldname) in the script to get the field values without spaces.

What are your actual values look like can you screenshot here?

Re: Button to exclude multiple items from field

userid128223 — Fri, 22 Sep 2017 21:15:54 GMT

could you explain what is happening in below formula

= '(' & Concat({< Student -= {'John', 'Mike'} >}Student, '|') & ')'

I understand that studen not equal t John & Mike. But what is the purpose of Concat

Re: Button to exclude multiple items from field

vishsaggi — Fri, 22 Sep 2017 21:21:52 GMT

Concat picks up multiple values so in this case it will pick student names other than John and Mike. Like Cline, Ivan and Venessa. So in a button action selection string this is how you will with hardcoded like

(Cline|Ivan|Vanessa) So with concat this is exactly what the concat picking like

(Cline|Ivan|Vanessa). hope this helps.

Re: Button to exclude multiple items from field

syedmazhar — Wed, 13 Feb 2019 07:11:44 GMT

If the values are more then 1000 then what could be the expression.And in my case i have some 400 values to exclude out of 1000 values from a dimension when i tap on exclude button. Please help me with the steps and expression.

Thanks in advance.