topic Keeping selected records and adding new ones to a selection... in App Development

Keeping selected records and adding new ones to a selection...

jerryr125 — Fri, 04 Feb 2022 16:45:11 GMT

Hi everyone -

I have a question in regards to selecting records in a table visualization.
Is there a way to accomplish the following :

For example - I sheet with a couple of filters and a table visualization displaying product name and other information about the product (simple). Say there is 1000 products.

Using the filter "Product name", the user filters on the product name "Wood Table" and the table visualization displays 50 products (50 lines) in the selection.

Now the user wants to select more products and NOT lose the result set of the 50 "Wood Tables".

Is there a way to accomplish this ?

For example, now the user wants to select Product name "Red Chair" in which there is 25 red chairs. Therefore the total result set is 75 products.

I have been doing some research - maybe alternate states ?

Not sure - any insight would be helpful - thanks so much - Jerry

Re: Keeping selected records and adding new ones to a selection...

jerryr125 — Fri, 04 Feb 2022 21:15:58 GMT

I think my answer may by with alternate states...

This is what I am looking to do:

https://youtu.be/gS4XWmE4JX0

Re: Keeping selected records and adding new ones to a selection...

mikaelsc — Fri, 04 Feb 2022 21:32:31 GMT

use an expression to exclude your selection on salesID in your first table:

sum({<salesID= >}QuantitySold)

Re: Keeping selected records and adding new ones to a selection...

jerryr125 — Sat, 05 Feb 2022 13:46:08 GMT

Hi - I am working on a solution using extensions - stay tuned - Jerry

Re: Keeping selected records and adding new ones to a selection...

JeffMelon — Wed, 15 Nov 2023 21:46:24 GMT

@jerryr125 Did you ever find a solution for this? I watched your video explaining the objective and I am looking to do the same.

Thank you