topic Re: set analysis for for multiple conditions of the same field in QlikView

set analysis for for multiple conditions of the same field

Anonymous — Tue, 20 Nov 2012 21:10:03 GMT

I would like to write a set analysis that shows me where a range of values DOES occur in table_1, field_a and DOES NOT have another range of in the same tabe and field. For example, Account ABC has an installed product listing like:

For example, I want to see every account here that has product 234 or 789, but does not have product 12345 or 345.

Meyer - NO, has 234 but also has 12345 - ignore.

Adams - YES, has 234 and does not have 12345 or 345

Jones - NO, has 234 and 789 but also has 12345

Smith - YES, 789 but does not have 12345 or 345

Account	Installed_Product
Meyer	12345
Meyer	6789
Meyer	234
Adams	234
Adams	6789
Jones	12345
Jones	6789
Jones	789
Jones	234
Smith	789
Smith	567

Re: set analysis for for multiple conditions of the same field

swuehl — Tue, 20 Nov 2012 21:23:24 GMT

Try something like

only({<Account = p({<Installed_Product={234,789}>}) - p({<Installed_Product= {12345,345}>}) >} Account)

Re: set analysis for for multiple conditions of the same field

erichshiino — Tue, 20 Nov 2012 21:32:35 GMT

Hi,

You need to operate with at least two sets.

The final set analysis would be more or less like this:

{<Installed_Product={234,789}>-<Installed_Product={12345,345}>}

For instance, to calculate the number of account that are the result of the difference between those two sets, you can use count( {<Installed_Product={234,789}>-<Installed_Product={12345,345}>} distinct Account)

Hope it helps,

Erich

Re: set analysis for for multiple conditions of the same field

Anonymous — Tue, 20 Nov 2012 23:51:36 GMT

Bingo - Thanks!

Re: set analysis for for multiple conditions of the same field

Anonymous — Tue, 20 Nov 2012 23:58:18 GMT

12345, 345 need to be '12345, '345'...