TEXTLIST() for displaying values

Hello all,

I've been wondering about a way to display selected values.

To give an example,

In my screenshot, three countries were selected and i like to display them to give users a sort of a recap.

So i tought using textlist() as follow :

However, it doesn't work and it seems that the problem resides in the fact that my List is in production data(which i really can't disable..).

Is there any way to display selected values within a line item ?

Thanks,

Hugo

Accepted answers

You can, if you remove country list from the line item's dimension (as it says in the error).

But let me suggest another solution to you.

It's not a best practice to use TEXTLIST if you can avoid it.

Which you can if you publish the module the second time, but now filtered by selected elements ('Save ?' = TRUE)

You can hide all the columns of this module. So you will get a list of selected countries only.

You can, if you remove country list from the line item's dimension (as it says in the error).

But let me suggest another solution to you.

It's not a best practice to use TEXTLIST if you can avoid it.

Which you can if you publish the module the second time, but now filtered by selected elements ('Save ?' = TRUE)

You can hide all the columns of this module. So you will get a list of selected countries only.

@KirillKuznetsov

Thank you for your quick reply !

Indeed, i didn't think about it that way !

That is a good solution ! Thanks !

Hugo

@KirillKuznetsov
Out of curiosity,

Why your first solution that consisted to remove the list from the module dimension is not preferable ?

Regards,

Hugo

Planual recommends to avoid it as it will affect the performance of the model

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…