set analysis help

Anonymous — Tue, 11 Aug 2015 11:53:18 GMT

Below is my set script .My requirement is i want to exclude particular department.

I tried with my set script .I am not sure this is correct .please correct if i am wrong.

sum({<Dept-={"NZA"}>}Gross_sales)

I need sum sum of gross sales exluding NZA department.

Thanks

Re: set analysis help

PrashantSangle — Tue, 11 Aug 2015 11:56:06 GMT

Hi,

Yes it is correct Syntax.

You can also use e() Indirect set analysis.

Regards

Re: set analysis help

maxgro — Tue, 11 Aug 2015 12:00:03 GMT

maybe (try both)

sum({<Dept=-{"NZA"}>} Gross_sales)

Re: set analysis help

Tue, 11 Aug 2015 12:04:26 GMT

Yes, its correct

Sum({<Dept-={'NZA'}>}Gross_sales)

Re: set analysis help

sunny_talwar — Tue, 11 Aug 2015 12:05:55 GMT

May be this:

=Sum({<Dept= E({<Dept = {'NZA'}>})>}Gross_sales)

Re: set analysis help

Anonymous — Tue, 11 Aug 2015 12:21:23 GMT

Thanks All

Re: set analysis help

mohammadkhatimi — Tue, 11 Aug 2015 12:22:03 GMT

Hie...

=Sum({<Dept= E({<Dept = {'NZA'}>})>}Gross_sales)

Hope this will helps u...

You can only use p() and e() function in a set analysis set modifier.

From the Help file:

Set Modifiers with Implicit Field Value Definitions

In the above examples, all field values have been explicitly defined or defined through searches. 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.

sum( {$<Customer = P({1<Product={‘Shoe’}>})>} Sales )
same as above. If the field in the element function is omitted, the function will return the possible values of the field specified in the outer assignment.

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

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

Regards,

Mohammad

topic Re: set analysis help in QlikView

set analysis help

Re: set analysis help

Re: set analysis help

Re: set analysis help

Re: set analysis help

Re: set analysis help

Re: set analysis help

Set Modifiers with Implicit Field Value Definitions