topic Re: Question about selected and non selected values in QlikView

Question about selected and non selected values

Anonymous — Wed, 23 Mar 2016 19:00:43 GMT

dear community:

I'm having a problem with the selected and non selected values that I hope you can help me with:

I have the following tables

I know that the green selection in the "X" table is a getfieldselection, where I can make decisions according to the value I'm comparing it with.

But right now, I have to set a variable according to the value that the "y" table is showing.

How can I do that?

Thank you very much

sunny_talwar — Wed, 23 Mar 2016 19:02:33 GMT

What comparison are you making? Not really sure I understand your requirement

swuehl — Wed, 23 Mar 2016 19:03:46 GMT

You can define your variable like

=Only( y )

=Concat(Distinct y ,', ')

or any other aggregation function that queries the values from y.

Anonymous — Wed, 23 Mar 2016 19:05:29 GMT

I want to set a variable between 0 and 1 if the field on the "y" table is 6 or 8.

I know that you can do a get field selection in some cases, but for the "Y" table I'm not selecting anything.

sunny_talwar — Wed, 23 Mar 2016 19:08:05 GMT

May be this:

If(SubStringCount(Concat(Distinct y, '|'), 6) = 1 or SubStringCount(Concat(Distinct y, '|'), 😎 = 1, 1, 0)

UPDATE: You can use Concat() to get the selections when you are not explicitly making a selection in a field

Anonymous — Wed, 23 Mar 2016 19:12:15 GMT

Thanks!

swuehl — Wed, 23 Mar 2016 19:14:01 GMT

Maybe like

=If( Max({<y *= {6,8}>} y), 1,0)

edit: Missed the intersection op