Selection of multiple option from list on UX pages

AdamSayyad

Hello Anaplaner,

Please find the attached Excel sheet along with the use case description below.

We have a use case where the end user requires a selection option on the UX page from a list (Product & Company). As you may be aware, there is currently no option available on the UX page to select multiple list members from a dropdown list, similar to how one would in an Excel pivot table.

Multiple Selection on UX page.xlsx

We have achieved this result by creating a system model that utilizes the same lists (Product and Company), where we added a Boolean line item for selection and published it on the UX page.

However, the drawback of this approach is that we must use a lengthy formula to attain the desired outcome. While the model is not large, and thus there are no latency issues, it would be greatly beneficial if there were an alternative approach to achieve this result.

Thank you for your attention to this matter.

@rob_marshall @Misbah

LauranceJ

HI @AdamSayyad

You may create a concatenated list which is created from those intersections where there is a value, this would enable you to be able to dimension a module by that and reduce your sparsity.

The user could then search the concatenated list for those members.

Many Thanks

Laurance