2 Replies Latest reply: Feb 11, 2015 2:38 AM by Avinash R

# Showing unassociated data

Hi,

I have a tricky scenario where i have a straight table and a set of charts. In the charts i want to show the data as per the filters, but in the straight table i want to show even the non-associated data.

For. e.g. I have a flag which selects data from data source A or B, both data sources are concatenated facts separated by a data source flag. They also have separate volume columns.

Now, when i select the Data Source A, the charts works fine, but the straight table is expected to show both the volume columns ir-respective of the flag which is selected. So, it has to show the data which is not associated. Also, the other filters should work with the un-associated data of Source B.

Let me know how this could be achieved in QlikView (preferably without using alternate states).

Regards,

Diwakar

• ###### Re: Showing unassociated data

Hi Diwakar,

Try with advanced set analysis, use p() and E() function you can achieve this requirement

• ###### Re: Showing unassociated data

Indirect Set Analysis

• p( ) = Possible

• e( ) = Excluded

Excluded

Possible

Customer = p({<Year={\$(=max(Year)-1)}>} Customer)

Returns customers who had an association to last year.

sum(({<Year={\$(=max(Year))},

Customer = p({<Year={\$(=max(Year)-1)} Customer>}) Sales)

Returns this year’s sales for customers who had sales last year.

sum({\$<CompanyName = p({\$<CategoryName={'Baby Clothes'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes.

The set p({}) returns the values of CompanyName (Customer) that

purchased Baby Clothes.

sum({\$<CompanyName = p({\$<CategoryName={'Baby Clothes'}>}

CompanyName) - p({\$<CategoryName={'SportsWear'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes but not

Sportswear.The first set p({}) returns CompanyName that purchased

Baby Clothes.The second set p({}) returns CompanyName that

Purchased SportsWear.The Unary Operator "-" between the two gives

a list of Customers (CompanyName)that belong to the first but not the

other set.