Discussion Board for collaboration on QlikView Layout & Visualizations.
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....
Go to Solution.
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.
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.
and the "Forward" selections:
You can then create two button/text boxes with an Action to make the respective selections in the field ABC.
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
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!