Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
michael_carson
Contributor III
Contributor III

Set analysis with two selections

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.

AccountNumberGroupCodeReasonCodeAmount
12345CO241
12345PR12
12345CO173
99999CO274
99999PR15

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

3 Replies
sunny_talwar

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

michael_carson
Contributor III
Contributor III
Author

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

sunny_talwar

You might be looking for this:

AND-Mode