Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to select all the countries on button click whose GDP is greater than upper range for its region.
For example:
Select in Field: Country
Search String: =vGDP >= [Upper Range] or =$(vGDP) >= [Upper Range]
However, no countries are getting selected. Can anyone help?
Thanks,
Let's try the below:
='(' & Concat(If(Aggr($(vGDP), Country)>= [Upper Range], Country), '|') & ')'
Thanks
Some thing like this will help.
Field: Country
Search String: = '("' & concat({<vGDP={'>=$(=Max(Range))'}>} Country,'" | "') & '')'
Thanks,
Hemanth.
Try the below in the search string:
='(' & Concat(If($(vGDP) >= [Upper Range], Country), '|') & ')'
Hi Sinan,
This somewhat helps but only one country is getting selected not all countries whose GDP is greater than upper range of its region.
Thanks,
What is in the variable, such Sum(), Count(), etc?
For vGDP ? Its sum.
Let's try the below:
='(' & Concat(If(Aggr($(vGDP), Country)>= [Upper Range], Country), '|') & ')'
Thanks
Perfect! Thank you so much!
You are welcome.