topic Re: Union in Set Analysis in QlikView

Union in Set Analysis

Thu, 08 Oct 2015 15:54:22 GMT

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

Re: Union in Set Analysis

sunny_talwar — Thu, 08 Oct 2015 20:20:17 GMT

Try this:

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

Re: Union in Set Analysis

sunny_talwar — Thu, 08 Oct 2015 20:23:58 GMT

Here is a simple example to look at:

Re: Union in Set Analysis

Fri, 09 Oct 2015 07:51:48 GMT

It works perfect. thanks a lot Sunny

Re: Union in Set Analysis

sunny_talwar — Fri, 09 Oct 2015 12:42:47 GMT

Awesome

I am glad it worked.

Best,

Sunny