topic Re: Showing unassociated data in QlikView

Showing unassociated data

diwakarnahata — Wed, 11 Feb 2015 07:32:44 GMT

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

avinashelite — Wed, 11 Feb 2015 07:35:32 GMT

Hi Diwakar,

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

Re: Showing unassociated data

avinashelite — Wed, 11 Feb 2015 07:38:44 GMT

to add little more details

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.