Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vlad_komarov
Valued Contributor 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

Tags (3)
1 Solution

Accepted Solutions
simondachstr
Valued Contributor III

Re: "Back" selections for single field only

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.

4 Replies
simondachstr
Valued Contributor III

Re: "Back" selections for single field only

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
Valued Contributor III

Re: "Back" selections for single field only

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
Valued Contributor III

Re: "Back" selections for single field only

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
Valued Contributor III

Re: "Back" selections for single field only

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

Community Browser