topic Re: filter join question in QlikView

filter join question

rzandieh — Mon, 14 Sep 2015 19:58:22 GMT

we have table A and table B joined on key

what we want to do is use table A to filter data and then

to be able to filter on the result set in table B based on

separate attributes of table B without affecting results in table A

is there a way to do that in QlikView ???

Re: filter join question

Oleg_Troyansky — Mon, 14 Sep 2015 20:12:54 GMT

It sounds like the "Loosely Coupled" tables functionality, however that is such a shaky ground, that I'd rather recommend using Set Analysis to disregard certain filters in certain expressions.

cheers,

Oleg Troyansky

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

Re: filter join question

rzandieh — Mon, 14 Sep 2015 21:09:43 GMT

Thank you for the response. We would like to be able filter on attributes in table B without it affecting Table A. how that can be accomplished using set analysis ?