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?
Solved! Go to 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]
)
)
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]
)
)
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?
Try
LOOKUP([_thisrow].[Name], "All List", "Logistic Name", "UID") & LOOKUP([_thisrow].[Name], "All List", "Retail Name", "UID")
Ohhh geniuss...thank you sooo much sir. Have a great day !
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |