topic AND operation on filters in QlikView

AND operation on filters

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a scenario where I want to combine 2 different filters and get the matching results of both in a chart. I want to get his done dynamically as in when the user select option A,B from filter 1 and option B,C from the filter 2, I want the 'C' and display it in a chart. Basically, this is performing an AND operation on filters. The data is coming from the same source for all the filters.

I'd appreciate any help provided.

Thanks

Re: AND operation on filters

jmvilaplanap — Wed, 05 Jul 2017 14:43:57 GMT

Hi Shalki

Could you give a better example (the qvw will be fine )

Good Luck

Re: AND operation on filters

dberkesacn — Wed, 05 Jul 2017 14:55:13 GMT

Hi, you have to study Set Analysis, with this you can achieve something similar, multiple filter with an AND Boolen Operator.

Here is a great article: https://www.resultdata.com/qlikview-set-analysis-guide/

Daniel

Re: AND operation on filters

effinty2112 — Wed, 05 Jul 2017 15:05:32 GMT

Hi Shalki,

When you say select option A,B from filter 1 do you mean select values A & B in "field1"? And does select option B,C from the filter 2 mean select values B & C in "field2"?

If you do then QlikView will combine these two selections as an AND, that is the records associated with these selections will be those for which the selections in both fields are valid.

Multiple selection of values within a single listbox (field) is like an OR

Cheers

Andrew