topic Re: Set Analysis - Setting a field equal to another field's selection in QlikView

Set Analysis - Setting a field equal to another field's selection

Wed, 04 Jun 2014 17:55:32 GMT

Is it possible to set a field equal to another field's selection using set analysis?

Re: Set Analysis - Setting a field equal to another field's selection

swuehl — Wed, 04 Jun 2014 17:57:11 GMT

Have you tried

{<FieldA = FieldB >}

Re: Set Analysis - Setting a field equal to another field's selection

Wed, 04 Jun 2014 18:03:46 GMT

I'm working on the expression that when I select in Field1 it will use the value of that selection in Field2 in the expression. Field 2 table is a subset of Field1 table. I was thinking of this expression but it does not work.

sum({<Field2=Field1>} Count1)

Re: Set Analysis - Setting a field equal to another field's selection

swuehl — Wed, 04 Jun 2014 18:07:34 GMT

How are your three fields related in your data model? Could you upload a small sample app?

Re: Set Analysis - Setting a field equal to another field's selection

Wed, 04 Jun 2014 18:07:59 GMT

To explain further, here's where I am now.

sum({$<Field2= {"John"}>} Count1)

I want that "John" to be the selected value of Field1.

Re: Set Analysis - Setting a field equal to another field's selection

Clever_Anjos — Wed, 04 Jun 2014 18:16:47 GMT

Try this, should work

sum({<Field2=P(Field1)>} Count1)

Re: Set Analysis - Setting a field equal to another field's selection

Anonymous — Wed, 04 Jun 2014 18:17:01 GMT

What about trying to set the selected value in Field1 into a Variable, and use this variable in set analysis?

The variable would be somethig like this:

vField1 = GetFieldSelections(Field1)

And the set analysis, using this variable:

sum({$<Field2= {$(vField1)}>} Count1)

Regards,

Gabriel

Re: Set Analysis - Setting a field equal to another field's selection

Wed, 04 Jun 2014 18:28:57 GMT

This worked perfectly. Can you explain a bit what the P does. Sorry, I'm a beginner.

Re: Set Analysis - Setting a field equal to another field's selection

Wed, 04 Jun 2014 18:32:16 GMT

From the help window:

There is however an additional way to define a set of field values by the use of a nested set definition.

In such cases, the element functions P() and E() must be used, representing the element set of possible values and the excluded values of a field, respectively. Inside the brackets, it is possible to specify one set expression and one field, e.g. P({1} Customer). These functions cannot be used in other expressions:

Examples:

sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )
returns the sales for current selection, but only those customers that ever have bought the product ‘Shoe’. The element function P( ) here returns a list of possible customers; those that are implied by the selection ‘Shoe’ in the field Product.

Re: Set Analysis - Setting a field equal to another field's selection

Wed, 04 Jun 2014 18:35:13 GMT

I end up using Clever's solution since I don't have to use variable. Thanks for the help anyway.

Re: Set Analysis - Setting a field equal to another field's selection

Clever_Anjos — Wed, 04 Jun 2014 18:36:29 GMT

Robert Daitzman already answered that

Think of "P" as "all possibilities" of field

There´s a less know "E" that stands for "except"

Re: Set Analysis - Setting a field equal to another field's selection

Wed, 04 Jun 2014 18:38:59 GMT

Thanks again for the help. This is my first post too:) I'm a happy camper!

Re: Set Analysis - Setting a field equal to another field's selection

Anonymous — Mon, 12 Mar 2018 12:19:47 GMT

Sorry, but this is correct only when Field1 value has only one possible value for Field2. If Field2 has more then one possible values for Field1 value, this is not correct.

Re: Set Analysis - Setting a field equal to another field's selection

aditi_rathi — Mon, 03 Sep 2018 16:21:28 GMT

This worked, thanks!