AND operation on filters

[#1]

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

[jmvilaplanap]

Hi Shalki

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

Good Luck

[dberkesacn]

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

[effinty2112]

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