Union in Set Analysis

[#1]

Dear Community,

I am trying to select an union of two selections in a set analysis. Reading the Doc, I understood I had to use the + sign and using the template wizard at Set Analysis Wizard for QlikView | qlikblog.at I was led to use a format like the one below

example: Sum({$<group={$(=nath)},division+={$(=gilles)}>}sales)

In my application I replicated it with below expression

sum({$<[Final Customer Group Code]={'2030'},[Final CG Others]+={'INVENSYS'}>} Sales)

Unfortunately, I can't get to see my Sales on the Union of the two sets. Only the first set ([Final Customer Group Code]={'2030'}) is included in the results

What I am doing wrong?

Thanks  lot for your help

[sunny_talwar · Accepted solution]

Try this:

=Sum({$<[Final Customer Group Code]={'2030'}> + <[Final CG Others] = {'INVENSYS'}>} Sales)

[sunny_talwar]

Here is a simple example to look at:

[#4]

It works perfect. thanks a lot Sunny

[sunny_talwar]

Awesome

I am glad it worked.

Best,

Sunny