topic Re: Need to select a set of values in a list box, using a button action. in QlikView

Need to select a set of values in a list box, using a button action.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Here's the list of values in the list box (or field)

YTD,

MTD,

Jan,

Feb,

Mar,

Dec

I created a button to help the user select all the months at one go - Toggle select.

Field_name: AdhocCols

String: (Jan|Feb|Mar|Apr|May|.........|Dec)

This works fine only if the user hasn't already selected one of the months in my list. If he has selected YTD, MTD, Jan & Feb already, then my button deselect Jan & Feb.

Please help. how do I make the button disregard the current selections in that field.

Re: Need to select a set of values in a list box, using a button action.

MK9885 — Thu, 21 Dec 2017 17:19:59 GMT

Direct selection in filter would clear all selections made by button.

I can only think of user holding 'Ctrl' key to select other fields too...as randomly selecting multiple fields.

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 22 Dec 2017 05:33:14 GMT

I don't think that's how it works. Consider there's just the listbox and a button. If a user makes a few selections in the listbox after clicking the button, the button selections do not clear away.

If the user selects YTD and MTD then click on my toggle select button for all months, all months get selected - another click of the button - the months (only the months) get deselected.

Only prob however - if the user has selected YTD, MTD, Jan, Feb then clicks the toggle button - Jan and Feb get deselected. Rest of the months get selected along with YTD and MTD.

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Thu, 04 Jan 2018 10:29:01 GMT

bump! Can someone please help me with this?

Re: Need to select a set of values in a list box, using a button action.

Miguel_Angel_Baeyens — Thu, 04 Jan 2018 15:49:38 GMT

Maybe you need to add a Clear Field action before the Select in Field? Then, every time you click on the button all specified values will be selected, regardless what was already selected by the user.

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 05 Jan 2018 05:44:04 GMT

Thanks Miguel! But unfortunately, I want my Month selections to happen in addition to the existing selections made by the user. All these values YTD, MTD, Jan....Dec are all in the same field.

Re: Need to select a set of values in a list box, using a button action.

Miguel_Angel_Baeyens — Fri, 05 Jan 2018 07:22:42 GMT

Sorry, I'm missing something: you have a field AdhocCols with the values

YTD,MTD,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec

And only these values.

The user can select whatever value from that listbox, and you want to provide them with a button to select ALL values, the use a simple star * in the Search String and always all values will be selected, regardless the selection. After a second thought, though, I don't know if this is the case why do you need the button at all, if the user can simply drag and drop in the listbox and select all values.

If my understanding is not correct, specify with your actual application the name of the fields, their values and the use case of such button (eventually with a sample app we can work with).

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 05 Jan 2018 07:32:09 GMT

Thanks for your reply Miguel. My mistake I should've given you the actual LOV

YTD

LYTD

MTD

LYMTD

LY-1MTD

LY-2MTD

LY-3MTD

LY-1YTD

LY-2YTD

LY-3YTD

Jan

Feb

Mar

Apr

May

Dec

Now the user wants just one button to select ALL MONTHS in addition to the existing selections he has made. If I clear field, I stand to lose the selections already in place. The toggle action works very well - except the fact that if the user has already selected a few months, those get deselected when the button is clicked.

Thank you so much for taking out time.

Re: Need to select a set of values in a list box, using a button action.

Miguel_Angel_Baeyens — Fri, 05 Jan 2018 08:35:47 GMT

Use the Concat() function to include the already selected values, something like:

='(Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dic|' & Concat(DISTINCT Field, '|') & ')'

In the Search String will take whatever is already selected plus all the months. If any month is already selected, it will not change.

So if the user has MTD and Feb, clicking the button with this function should select all months plus the MTD which was already selected.

Re: Need to select a set of values in a list box, using a button action.

susovan — Fri, 05 Jan 2018 09:07:39 GMT

Hi,

You will be get the requisite after double click on the button.

PFA

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 05 Jan 2018 09:49:48 GMT

Thanks Miguel! Let me try this out

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 05 Jan 2018 09:52:25 GMT

Gonna try this out thank you so much for this. Will update shortly.

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 05 Jan 2018 10:12:17 GMT

This didn't work

I added this in the search string but the button action does nothing.

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 05 Jan 2018 10:13:49 GMT

No Susovan this didn;t work. The whole prob is this - selecting all the months happens using your method but it deselects the user selections that already exist. In my case I want to select the months in addition to the YTD, MTD etc. selections.

Re: Need to select a set of values in a list box, using a button action.

Miguel_Angel_Baeyens — Fri, 05 Jan 2018 10:22:07 GMT

It does work for me. You will need to change the field name to whichever is yours, likely.

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 05 Jan 2018 10:27:07 GMT

Thanks! Let me see why it isn't working in my app. Will update shortly.

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 05 Jan 2018 10:37:52 GMT

Yay! Thank you Miguel. I had missed to replace field name

Re: Need to select a set of values in a list box, using a button action.

Anonymous — Fri, 05 Jan 2018 10:51:33 GMT

One question though - when I use this, the current selection field shows multiple values for months. How can I avoid that?

Re: Need to select a set of values in a list box, using a button action.

Miguel_Angel_Baeyens — Fri, 05 Jan 2018 10:54:26 GMT

You cannot, the current selection object displays whatever selection is made in the current document. If you select them manually the appearance will vary (e.g.: you don't need to use "(" or "|") but the result is the same.

Re: Need to select a set of values in a list box, using a button action.

Miguel_Angel_Baeyens — Fri, 05 Jan 2018 10:57:02 GMT

Cannot edit so reply to myself for further clarification:

If you mean every month appears twice, it is correct, one is the selected value by the user the other is the string you use in the Search In String
If you mean you see the (Jan|Feb|...) in the selection box is also correct. If you manually type this expression in the listbox search function, you will select indeed these values.