Sure, there we go.
So, I left some selections already like this:
List 1 PRE-SELECTED (Removes when Selected) List 2 ALL OPTIONALS (Adds when Selected) Result Optional 1 Optional 3 (Everything on List 1, REMOVING the Red Selections) Optional 14 Optional 4 Optional 3 Optional 15 Optional 5 Optional 4 Optional 16 Optional 6 Optional 5 Optional 26 Optional 7 Optional 6 Optional 28 Optional 8 Optional 7 Optional 37 Optional 19 Optional 8 Optional 27 Optional 20 Optional 19 Optional 39 Optional 21 Optional 20 Optional 41 Optional 30 Optional 21 Optional 42 Optional 1 Optional 30 Optional 43 Optional 2
So, the 'RESULT LIST' should have everything on 'LIST 1' without the Selections PLUS Adding the Selections from 'LIST 2'.
Please find the attached document. This is one such way, which came up in my mind.
We are setting values of selected fields into variables and then passing these variables at the script.
Hope it helps.
QVW_sample_ASINGH.qvw 157.5 K
Thank you for replying, your idea is totally correct.
However, since my 'LIST 1' is a variable list coming from more then one XLS, I can't set them.
What I tried to use is creating 2 Variables like these:
(vALL_OPT For ALL OPTIONALS)
=Chr(39)&Replace(GetFieldSelections([ALL OPTIONALS],',', GetSelectedCount([ALL OPTIONALS])), ',' , chr(39)&','&chr(39)) &chr(39)
(vPRE_OPT For PRE-SELECTED)
=Chr(39)&Replace(GetFieldSelections([OPTIONALS PRE-SELECTED],',', GetSelectedCount([OPTIONALS PRE-SELECTED])), ',' , chr(39)&','&chr(39)) &chr(39)
And adding this to a List Expression:
So the List changes as the Optionals are selected (I mean, in real time), that's what I need mostly!
However, my Expression or Variable is wrong because with this Expression, I'm Adding the values of 2 lists into one, and I need 1 to add and 1 to remove, as I explained.
It's a little bit hard to understand i confess, if you need something, let me know please! I do need to get this working!
Thank you so much!
QVW_sample_ASINGH.qvw 159.2 K