topic Re: Input box to select and deselect particular items in QlikView

Input box to select and deselect particular items

markgraham123 — Tue, 05 Jul 2016 15:58:28 GMT

Hi all,

I'm using an input box to select large number of items at a time using the below string.

='(' & Replace(Replace(Replace(Trim('$(vSelect)'), ' ', '|'),' ', '|'), chr(10), '|') & ')'

Can someone help me with string - To show the items other than the selected items

Any help is highly appreciated!

Re: Input box to select and deselect particular items

sunny_talwar — Tue, 05 Jul 2016 16:07:05 GMT

What is your definition for vSelect?

Re: Input box to select and deselect particular items

markgraham123 — Tue, 05 Jul 2016 16:13:33 GMT

vSelect takes the list of items.

Re: Input box to select and deselect particular items

sunny_talwar — Tue, 05 Jul 2016 16:14:29 GMT

Is it picking those using GetFieldSelections()?

Re: Input box to select and deselect particular items

markgraham123 — Tue, 05 Jul 2016 16:16:26 GMT

Sunny,

It is a trigger whose action is set to select items:

='(' & Replace(Replace(Replace(Trim('$(vSelect)'), ' ', '|'),' ', '|'), chr(10), '|') & ')'

This works to get all items from spreadsheet and copy it in input box to select all those items.

Re: Input box to select and deselect particular items

sunny_talwar — Tue, 05 Jul 2016 16:19:38 GMT

I understand that, but You have used vSelect in your expression above. Just trying to understand what vSelect is?

Re: Input box to select and deselect particular items

markgraham123 — Tue, 05 Jul 2016 16:21:34 GMT

sunny,

I created a vSelect variable to store all items into it.

Re: Input box to select and deselect particular items

sunny_talwar — Tue, 05 Jul 2016 16:23:03 GMT

Is this done manually? or using an expression?

Re: Input box to select and deselect particular items

markgraham123 — Tue, 05 Jul 2016 16:24:45 GMT

Here is the sample app.

Re: Input box to select and deselect particular items

sunny_talwar — Tue, 05 Jul 2016 16:27:10 GMT

So in this example you would want to see 2 and 3 selected because 1 is entered in the input box? Sorry I did not know you were using input box for vSelect

Re: Input box to select and deselect particular items

markgraham123 — Tue, 05 Jul 2016 16:28:44 GMT

yes sunny...

i want to see items other than which were selected.

If 1 is selcted, we need 2 and 3

Re: Input box to select and deselect particular items

sunny_talwar — Tue, 05 Jul 2016 16:31:25 GMT

Created another variable: vSelectExcluded and added another action of Select Excluded. See if this serves your purpose

Re: Input box to select and deselect particular items

markgraham123 — Tue, 05 Jul 2016 16:57:08 GMT

That's perfect buddy