About Set Analysis

[#1]

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!

[Anonymous]

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.

[#3]

Thanks Michael.

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

[marcohadiyanto · Accepted solution]

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

[#5]

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?

[marcohadiyanto]

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

[#7]

Thank you for the prompt answer!

[Anonymous]

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

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

[#9]

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!

[#10]

Maybe it's working. Sorry!