Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vlad_komarov
Partner - Specialist III
Partner - Specialist III

"Back" selections for single field only

Hello all,

I would need to implement a functionality to replicate "Back" and "Forward" selections for single field only ('ABC' from example below).

I thought I will be able to achieve that with using the following Actions sequence:

"Lock All-->UnlockField (ABC)-->Back-->LockField(ABC)-->UnclockAll"

But it does not work.

Tried without "LockField(ABC)" step as well, but with the same results.

The "Clear Field(ABC)" works fine if placed instead of "Back" call....

Will appreciate any suggestions....

Thank you!

Vladimir

1 Solution

Accepted Solutions
simondachstr
Luminary Alumni
Luminary Alumni

You can make multiple selections in "Select in Field", however the values need to be presented in a certain format e.g. (value1|value2|value3).

That's why I have put parenthesis to the expressions above and set | to be the delimiter.

View solution in original post

4 Replies
simondachstr
Luminary Alumni
Luminary Alumni

Use two variables to maintain the "Back" and "Forward" selections.

The "Back" selections will be kept using a Concat() function and set analysis e.g.

=&'('&Concat($1 ABC,'|')&')'

and the "Forward" selections:

=&'('&Concat($_1 ABC,'|')&')'

You can then create two button/text boxes with an Action to make the respective selections in the field ABC.

vlad_komarov
Partner - Specialist III
Partner - Specialist III
Author

Martin,

Thank you for the idea.

I need to play with it a bit (for example how to adjust this concatenated string to be used in actual Selections process), but I like the approach.

The "Select in Field" allows selecting one value at a time, correct? Not sure how to work around this limitation.

Any reason you've added parenthesis to this strings above? I do not think they need to be there, especially if you need to use this string during "Select in Field" calls

Regards,

Vladimir

simondachstr
Luminary Alumni
Luminary Alumni

You can make multiple selections in "Select in Field", however the values need to be presented in a certain format e.g. (value1|value2|value3).

That's why I have put parenthesis to the expressions above and set | to be the delimiter.

vlad_komarov
Partner - Specialist III
Partner - Specialist III
Author

Did not know about this "Select in Field" functionality (I guessed about '|', but had no idea that you need parenthesis there as well)...

Thanks, it works like a charm!

Regards,

Vladimir