Selection based on aggregation

[Anonymous]

Hello community,

I have a pivot table that is of the following structure:

field1	field2	field3	var1	var2	var3
2017	countryA	city	0.05	210	1

What I want is to select all countries from the dataset that have a variable [var3] value as "1" by clicking on a button. I have tried to do the following in the search string:

=if (Aggr($(var3),field2)=1, field2)

But, it is not returning anything. Of course, I performed concatination with "|". Does anyone has an idea on how to perform this?

Thanks

[vinieme12]

can you post a sample app?

[YoussefBelloum]

Hi,

Try this:

• Create a variable vTest

• Associate the variable with an action via a button or textobject: Set the variable to 1 for example when you click on the button.

• create a listbox with an expression like this:

                =if(vTest=1,if(var3=1, field2),field2)

[prat1507 · Accepted solution]

Use this

='('&chr(34)&Concat(Distinct(if (Aggr($(var3),field2)=1, field2)),chr(34)&'|'&chr(34))&chr(34)&')'

[Anonymous]

I've done the same, apart from the "distinct", but no results. Only ("")

[prat1507]

Paste a text box and check what are you getting, please ping me what you're getting.

It should be like ("Value 1"|"Value2"|"Value 3")..... something like this!!

Regards
Pratyush

[Anonymous]

Yes, I realized that I should get something in the mentioned form, but as a result I am getting ("") .