Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use this
='('&chr(34)&Concat(Distinct(if (Aggr($(var3),field2)=1, field2)),chr(34)&'|'&chr(34))&chr(34)&')'
can you post a sample app?
Hi,
Try this:
=if(vTest=1,if(var3=1, field2),field2)
Use this
='('&chr(34)&Concat(Distinct(if (Aggr($(var3),field2)=1, field2)),chr(34)&'|'&chr(34))&chr(34)&')'
I've done the same, apart from the "distinct", but no results. Only ("")
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
Yes, I realized that I should get something in the mentioned form, but as a result I am getting ("") .