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

[ashishpalkar]

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..

[ashishpalkar]

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))

[#3]

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?

[ashishpalkar]

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 ..

[#5]

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?

[ashishpalkar]

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

[#7]

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

Just so you know, I didn't ignore it

[#8]

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?

[ashishpalkar]

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

[Anonymous]

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

[stigchel]

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