Multiple select on multiple fields with OR operator?

[#1]

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:

a

b

c

d

e

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]

Hi Matei,

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

http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/

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

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense