topic Re: GetFieldSelections() - show selected values in list box/table in QlikView

GetFieldSelections() - show selected values in list box/table

ashishpalkar — Tue, 09 Feb 2016 21:24:39 GMT

Hi There

I am using GetFieldSelections(), and it given me output like

what I want to achieve is , the values selected from GetFieldSelections() should show in a list box where I can select / un-select. like below

Thanks in advance..

Re: GetFieldSelections() - show selected values in list box/table

sunny_talwar — Tue, 09 Feb 2016 21:27:17 GMT

You can specify its third parameter so that it doesn't group things:

Something like this:

=GetFieldSelections(Year, ',', 100000)

Re: GetFieldSelections() - show selected values in list box/table

ashishpalkar — Tue, 09 Feb 2016 21:32:59 GMT

Thanks Sunny, but this doesn't helped...

Re: GetFieldSelections() - show selected values in list box/table

sunny_talwar — Tue, 09 Feb 2016 21:50:31 GMT

You want to make selection and use that selection to create another list box for selection? I don't understand the point of this?

Re: GetFieldSelections() - show selected values in list box/table

ashishpalkar — Tue, 09 Feb 2016 21:54:58 GMT

yes, this is a requirement. I have around 500+ attributes.

Re: GetFieldSelections() - show selected values in list box/table

ashishpalkar — Wed, 10 Feb 2016 16:20:31 GMT

Hi There

Does anyone knows better workaround for this?

Re: GetFieldSelections() - show selected values in list box/table

Wed, 10 Feb 2016 16:50:51 GMT

You can try creating a straight table. It won't be exactly per your requirements but might work

Dimension - Year

Expression - 1

-Hide the expression column

Suppress header row

Create conditional show in layout tab - GetSelectedCount(Year)

See attached

Re: GetFieldSelections() - show selected values in list box/table

stigchel — Wed, 10 Feb 2016 17:02:35 GMT

You can use a listbox with an expression instead of an field (on the bottom of the field list choose <expression>) and for expression like

=Aggr(Only(Year),Year)

This will display only the selected years

Re: GetFieldSelections() - show selected values in list box/table

Wed, 10 Feb 2016 17:05:40 GMT

You can try Aggr( Year ,Year) to discard the excluded values from List box

GetFieldSelections have 3rd parameter to show how many values.

getfieldselections ( FieldName [, ValueSep [, MaxValues]])

Returns a string with the current selections in a field.

ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

Re: GetFieldSelections() - show selected values in list box/table

Wed, 10 Feb 2016 17:05:52 GMT

Try perhaps

=aggr(only(Datum),Datum)

as a Expression for your listbox. If nothing is selected all values are shown, but otherwise it fullfills your requirement. So add a if like:

=if(GetSelectedCount(Datum)>0,aggr(only(Datum),Datum))

(my field names come from my test application)

Hope I could help

Re: GetFieldSelections() - show selected values in list box/table

ashishpalkar — Wed, 10 Feb 2016 18:28:47 GMT

Thanks tuffelchen ..

it really worked , one more thing how can we add multiple attributes in this expression?

e.g

=if(GetSelectedCount(Datum,Datum1)>0,aggr(only(Datum,Datum1),Datum,Datum1))

Re: GetFieldSelections() - show selected values in list box/table

Thu, 11 Feb 2016 07:49:16 GMT

With

=if((GetSelectedCount(Datum)+GetSelectedCount(Zeitstempel))>0,aggr(only(Datum)& '-' &only(Zeitstempel),Datum,Zeitstempel))

you will get a combination of Datum and Zeitstempel seperated by '-' but you can fill in every other sign.

In this case every possible combination even if not seperated will be shown

Is this what you want?

Re: GetFieldSelections() - show selected values in list box/table

ashishpalkar — Thu, 11 Feb 2016 15:21:46 GMT

Hi , thanks for updates

here is what is required

=if(GetSelectedCount(Datum)>0,aggr(only(Datum),Datum)) - List box 1

=if(GetSelectedCount(Zeitstempel)>0,aggr(only(Zeitstempel),Zeitstempel)) - List box 2

I am looking to combine List Box 1 and List Box 2 into one ..

Re: GetFieldSelections() - show selected values in list box/table

Fri, 12 Feb 2016 08:11:11 GMT

Should it be a combination of Datum and Zeitstempel or should it be 2 (or more) listboxes standing next to each other (by a containerbox) following the same logic?

Can you show an example/draw one?

Re: GetFieldSelections() - show selected values in list box/table

ashishpalkar — Fri, 12 Feb 2016 18:40:34 GMT

It should be combination of Datum and Zeitstempel in one list box..

Re: GetFieldSelections() - show selected values in list box/table

Mon, 15 Feb 2016 15:55:34 GMT

Until now I tried a few things but didn't had the right/working idea

Just so you know, I didn't ignore it

Re: GetFieldSelections() - show selected values in list box/table

Mon, 15 Feb 2016 19:17:47 GMT

So, after a little more trying:

I didn't find any way to list different dimensions in a ListBox. What i found is that getCurrentSelections() can give you the selections.

I don't know what your request was, but it doesn't make much sense to me, to combine different dimensions in one listbox

Do you only what to show the selection or should it be something else more fancy?

Re: GetFieldSelections() - show selected values in list box/table

ashishpalkar — Tue, 16 Feb 2016 15:17:57 GMT

HI, thanks again.. just want to show selections nothing fancy as such...

Re: GetFieldSelections() - show selected values in list box/table

Anonymous — Tue, 16 Feb 2016 15:38:21 GMT

Hi,

You shoul just hide the excluded values

You will then have

You can then make new selections in the selected values.

I think that is what you need, isn't it?

Otherwise, you will have to duplicate your field

For exemple if you have a field Year,

you will have to creat a new table (using the script):

Year2:

LOAD

Year,

Year as Year2

RESIDENT

CALENDAR; // (Instead of CALENDAR use the name of the table containing your existing field Year)

Then you will have a field named Year2 depending on the selection of your field Year

Re: GetFieldSelections() - show selected values in list box/table

stigchel — Tue, 16 Feb 2016 15:58:59 GMT

Are you aware of the new sheet object\current selections box object? It displays all current selections and you can clear/ select from drop down. If this is too limited for you, search for better current selection box on this forum