- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Objeto texto
Buen dia a todos
de antemano agradezco mucho su ayuda con los siguiente, quiero crear un objeto de texto el cual al realizar un filtro por paises, si seleccino todos me de como resultado "todos los Paises" de lo contrario si selecciono todos menos un pais, me de como resultado ...por ejemplo "todos Menos Costa Rica",,, mil gracias por su ayuda soy nuevo experimentando con esta magnifica herramienta.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For a start, lets translate your request for all to appreciate your question:
Good day to all
thank you in advance for your help with the following, I want to create a text object which would display a filter by country, if I select "All", as a result it would show me "All Countries"; otherwise, if I select "All but one country", how can I get the result ... for example "all Less Costa Rica",,, thank you for your help I am experiencing with this great new tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Try like this
= If(Count({1}DISTINCT Country) = Count(GetFieldSelections(Country)),'All Countries ', GetFieldSelections(Country,',',1000))
Please close the thread by marking correct answer & give likes if you like the post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think this expression could help answer your need / Creo que esta expresión podría ayudar a responder a sus necesidades
=If( Count(DISTINCT Country) = Count({1} DISTINCT Country)
, 'All Countries/Todos los paises'
, If ( Count({1} DISTINCT Country)-Count(DISTINCT Country) = 1 and GetSelectedCount(Country, True()) > 1
, 'All countries less/Todos menos ' & Only({<Country=E(Country)>} Country)
, If ( not IsNull(Only(Country))
, 'Only/Sólo ' & Only(Country)
, 'Many countries selected/Muchos países seleccionados')))
Regards/Saludos cordiales,
Philippe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No soy bueno con el ingles pero Muchas Gracias......
excellent
thank you very much to you both for your help, phillip thanks to my brother 100% functional,that detallazo