topic Re: Use a single filter to check multiple columns with OR not AND in App Development

Use a single filter to check multiple columns with OR not AND

nate_ak — Fri, 02 Apr 2021 08:03:08 GMT

I would like to allow a user to choose values from a single filter dimension and apply the selection to two columns with OR logic as opposed to AND. For example:

Account Number	Primary Officer	Secondary Officer
123	A	B
456	C	A
789	B	C
012	A	A

An officer can be the primary or secondary officer (or both) of an account. I would like to have a single "Officer" filter dimension that a user can choose from to display all accounts an officer is associated with, whether it be primary or secondary (or both). So if a user chose "Officer A" from the filter it should result in the following:

Account Number	Primary Officer	Secondary Officer
123	A	B
456	C	A
012	A	A

All of the data resides in the same source table (QVD). So I don't mind doing the necessary logic in the data load editor or via Master Items.

Re: Use a single filter to check multiple columns with OR not AND

Marcos_rv — Fri, 02 Aug 2019 19:11:47 GMT

You could create an auxiliary table that helps you to group, for example:

table_aux:
load accnro,
official1 AS official_aux
resident table 1;

concatenate (table_aux)
table_aux:
load accnro,
official2 AS official_aux
resident table 1;

final:
load distinct
accnro, // key
official_aux as official_final
resident table_aux;

drop table table_aux;

The "final" table will be related by accnro to your fact table, you should use the "official_final" field as a filter, that will work for your OR.

regards!!!!

Re: Use a single filter to check multiple columns with OR not AND

nate_ak — Fri, 02 Aug 2019 21:06:12 GMT

Perfect! This did the trick quite nicely. Thank you!