topic Re: Multiple select on multiple fields with OR operator? in QlikView

Multiple select on multiple fields with OR operator?

Thu, 15 Oct 2015 13:22:22 GMT

Hello, i have this situation:

I need to do a select on a field with multiple values and to the result i want to add another select on another field!

Is that possible?

Example

TableA,TableB,Table_Result

TableA and TableB contains data about the TableResult

TableA is the parent of TableB

Soo if i want to select a field in TableA the possibilites in TableB are affected!

TableA contains:

Type

Group

TableB contains:

Type can be only a b or c

Group can be only b c d e

How can i make a select of type a and b or Group b c and d?

Oleg_Troyansky — Thu, 15 Oct 2015 14:09:26 GMT

Hi Matei,

if you need to facilitate this selection using list boxes, check out this blog article:

If you need the same within a Set Analysis condition, you can use function P() and E() to add up (union) different sets, like this:

sum( {<Type = P({<Type = {a, b, c}>} Type) + P({<Group={b, c, d, e}>} Type)>} Sales)

cheers,

Oleg Troyansky