Expression Issues

[syahir]

Hello all,

I have questions. Let's say I have an interface as below.

My intention is that whenever I click one of the country, "Name" will return Lists of selected Country combine both Logistic and Retail name such as below table called "All List"

I try to use the expressions Valid If "All List[Logistic Name]"but only one column return. How do I return value both Logistic and Retail Name whenever I click the Country? What expressions should I use?

[TeeSee1 · Accepted solution]

You can simply concatenate the two columns using "+" operator.

You also want to filter on the Country column and exclude blank values, so try something like

SELECT(
 All List[Logistic name], 
 AND(
   [Country] = [_ThisRow].[Country],
   ISNOTBLANK([Logistic Name]
 )
)
+ 
SELECT(
 All List[Retail Name], 
 AND(
   [Country] = [_ThisRow].[Country],
   ISNOTBLANK([Retail Name]
 )
)

[syahir]

Great! It works. Thanks a lot. Can I ask another questions here?

If I have another column "Code" which return the value UID in above table, how system will search between both column.

I try to use Lookup like this to return value UID whenever user click any Name but failed.

LOOKUP([_thisrow].[Name], "All List", "Logistic Name", "UID") + LOOKUP([_thisrow].[Name], "All List", "Retail Name", "UID")

What is the correct way doing the expressions?

[TeeSee1]

Try

LOOKUP([_thisrow].[Name], "All List", "Logistic Name", "UID") & LOOKUP([_thisrow].[Name], "All List", "Retail Name", "UID")

[syahir]

Ohhh geniuss...thank you sooo much sir. Have a great day !