topic Re: Selection based on aggregation in QlikView

Selection based on aggregation

Anonymous — Wed, 20 Dec 2017 13:07:22 GMT

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

Re: Selection based on aggregation

vinieme12 — Wed, 20 Dec 2017 13:15:34 GMT

can you post a sample app?

Re: Selection based on aggregation

YoussefBelloum — Wed, 20 Dec 2017 13:16:20 GMT

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)

Re: Selection based on aggregation

prat1507 — Wed, 20 Dec 2017 13:30:01 GMT

Use this

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

Re: Selection based on aggregation

Anonymous — Wed, 20 Dec 2017 13:41:12 GMT

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

Re: Selection based on aggregation

prat1507 — Wed, 20 Dec 2017 13:45:21 GMT

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

Re: Selection based on aggregation

Anonymous — Wed, 20 Dec 2017 13:47:28 GMT

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