topic Re: Set analysis ignores my sub-selection when defined a range of values in QlikView

Set analysis ignores my sub-selection when defined a range of values

Tue, 23 Feb 2016 08:08:50 GMT

Hi,

I defined in the expression to only view a specfic set of data, but I might want to view only a sub-part of the presentation by selecting one (or more) of the possible values. Unfortunately, I don't know how to do this... It always sticks to the selections made in the set analysis expression. Since 'C' is a value of the array 'A,B,C,D,E' I would think this should work?

Script:

Test:

load * inline [

Name, Salary

A,10

B,20

C,30

D,40

E,50];

Set analysis expression: sum({<[Name]={'A','B','C','E'}>} Salary)

Re: Set analysis ignores my sub-selection when defined a range of values

sunny_talwar — Tue, 23 Feb 2016 17:28:17 GMT

Try this:

Sum({<[Name] *= {'A','B','C','E'}>} Salary)

Re: Set analysis ignores my sub-selection when defined a range of values

swuehl — Tue, 23 Feb 2016 17:28:39 GMT

I believe you want to use the intersection operator * here:

sum({<[Name] *= {'A','B','C','E'}>} Salary)

Re: Set analysis ignores my sub-selection when defined a range of values

Oleg_Troyansky — Tue, 23 Feb 2016 17:31:57 GMT

In Set Analysis, when you add a filter Name={something}, the equals sign "=" means "replace user selections with this". So obviously any of your selections in the same field will get ignored, or more accurately, replaced with the filter values.

In order to allow both selections, you need to add one of the Boolean operators before the + sign. For example, this should do what you are looking for:

sum({<[Name]*={'A','B','C','E'}>} Salary)

*= means the intersection of user selections with the list of values. So, when nothing is selected, you will get A, B, C, E. If you select one of the four values, you will get just what you've selected.

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy and Austin, TX!

Re: Set analysis ignores my sub-selection when defined a range of values

Oleg_Troyansky — Tue, 23 Feb 2016 17:33:21 GMT

with Sunny and Stefan here, why even bother? 🙂

Re: Set analysis ignores my sub-selection when defined a range of values

Colin-Albert — Tue, 23 Feb 2016 17:35:04 GMT

One of Henric's hic‌ recent blogs gave an overview of Set operators

Implicit Set Operators

Re: Set analysis ignores my sub-selection when defined a range of values

Wed, 24 Feb 2016 07:23:15 GMT

Wow, what a team!!

Thanks a lot for all the replies! Needless to say, they were all correct!

Unfortunately I can only select one as 'THE' correct answer... but kudos for all of you .

Love this forum and it's members.