Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

Union in Set Analysis

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

1 Solution

Accepted Solutions

Re: Union in Set Analysis

Try this:

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

4 Replies

Re: Union in Set Analysis

Try this:

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

Re: Union in Set Analysis

Here is a simple example to look at:

Capture.PNG

Not applicable

Re: Union in Set Analysis

It works perfect. thanks a lot Sunny

Re: Union in Set Analysis

Awesome

I am glad it worked.

Best,

Sunny