topic Re: About Set Analysis in QlikView

About Set Analysis

Wed, 27 Jun 2012 01:07:38 GMT

Hi,

I am new to QlikView, and don't quite understand the feature of the Set Analysis.

Here is my case:

I have two standalone tables (A, B) that are not linked. In both tables, there is a column, called Product.

There are two sheets (1, 2) with charts that have been associated with each table.

If I make some selection of products in a chart in sheet 1, how to reflect the selection changes in sheet 2, based on the product selection in sheet 1.

It seems that I should use Indirect Set Analysis. I tried several ways, but none of them worked.

Appreciate your help. Thank you!

Re: About Set Analysis

Anonymous — Wed, 27 Jun 2012 01:45:39 GMT

If both table have a field named Product, that means they are linked. If you make selections in Product, it changes all data, no matter where the objects are loacted, same sheet or different sheets.

Re: About Set Analysis

Wed, 27 Jun 2012 02:22:45 GMT

Thanks Michael.

Actually I have unqualified the Product field, so it looks like A.Product and B.Product

Re: About Set Analysis

marcohadiyanto — Wed, 27 Jun 2012 05:43:57 GMT

if you want to make associative then you can use set analysis.

first you must make a variable to catch value from product that already selected. ex vProduct=A.Product

then in your set analysis you can make like this

sum({<B.Product= {$(vProduct)} >} value)

so what happend selection on a.product it changing the b.product too.

note: it can only for one selection only.

hope it helps.

Marco

Re: About Set Analysis

Wed, 27 Jun 2012 06:26:54 GMT

Thanks a lot, Marco. This is very clear!

However, I want to extend the topic - adding more fields to drill down. What if in both tables, there are Product & Department info. And I want to select Product and then Department, or Department and then Product in table A, then reflect the selection in table B. What will the set analysis statement look like?

Re: About Set Analysis

marcohadiyanto — Wed, 27 Jun 2012 06:35:11 GMT

if you want to combine product and departement then you can add more dimension on your set analysis.

ex. sum({<B.Product= {$(vProduct)}, B.Departement={$(vDepartement) } >} value)

Regards,

Marco

Re: About Set Analysis

Wed, 27 Jun 2012 06:58:36 GMT

Thank you for the prompt answer!

Re: About Set Analysis

Anonymous — Wed, 27 Jun 2012 10:16:40 GMT

It can work with multiple Products/Departments selections, and no variables needed:

sum({<B.Product= P(A.Product), B.Departement=P(A.Departement)>} value)

Re: About Set Analysis

Wed, 27 Jun 2012 17:07:21 GMT

Hi Michael,

How to add the condition to the following statement?

Sum(If(B.DATE =("BeginDateRange"), B.Value, Null()))

This doesn't work.

Sum({<B.Product= P(A.Product), B.Departement=P(A.Departement)>} If(B.DATE =("BeginDateRange"), B.Value, Null()))

Thanks!

Re: About Set Analysis

Wed, 27 Jun 2012 17:31:40 GMT

Maybe it's working. Sorry!