topic Re: Set analysis with two selections in QlikView

Set analysis with two selections

Anonymous — Tue, 04 Oct 2016 20:37:59 GMT

I am looking to setup a table that will display information based on multiple selections. It also needs to show the ENTIRE record, so long as that record includes the selection.

AccountNumber	GroupCode	ReasonCode	Amount
12345	CO	24	1
12345	PR	1	2
12345	CO	17	3
99999	CO	27	4
99999	PR	1	5

My goal is to select CO, 24 and then also include accounts that have the PR GroupCode and 1 as a ReasonCode.

I would expect that AccountNumber 12345 comes back and it does not just show the CO 24 and PR 1 but also shows the other CO 17 listed under that account.

When i use:

$<AccountNumber=P(AccountNumber), ReasonCode =, GroupCode= >}Amount

I get it partially, although when i make the selections i want, it looks for anyone who has a GroupCode of CO AND PR AND it is reason code 24 AND 1

Re: Set analysis with two selections

sunny_talwar — Tue, 04 Oct 2016 20:57:20 GMT

What selections are you making which is not giving you undesired result?

Re: Set analysis with two selections

Anonymous — Tue, 04 Oct 2016 21:43:38 GMT

When I select pr and co from selections I see anyone that has either the pr or the co. Same for the reason codes.

Re: Set analysis with two selections

sunny_talwar — Tue, 04 Oct 2016 22:59:32 GMT

You might be looking for this:

AND-Mode