Filtering Data According To More Than One Condition

[doganogulturk]

Hi.

My data has Person, Gender, Firm, Total columns. I want users to filter data like that:

Gender: Male

and

Firm: Firm 1

or

Gender: Female

and

Firm: Firm 2

I want to see this expression sum(Total)=210 (10+200)

By using Gender and Firm as a listbox, how can I do that?

Note: Users can change the selections. The selections above are just sample.

[m_woolf]

Compound Search - demystified

[prieper]

With alternate states you may create two additional listboxes (for the second selection-condition). In the table you may then refer to expressions referring to the selections (default of alternate).

Else you may have to combine the field-combinations "Gender" and "Firm" into one field and make the selections there (may also use treeview then).

Peter

[effinty2112]

Hi Doğan,

I'm interested to know why there might be an objection to doing the most simple thing, two listboxes, one for Gender and one for Firm.

Cheers

Andrew

[doganogulturk]

Hi. Thanks for your replies.

If i learn that, i will apply the solution to my main data.

I found a solution here: Using Alternate States to Select Multiple Value... | Qlik Community

Do you thing it is useful for me? I couldn't apply this solution.

[doganogulturk]

Hi. Thank you for reply. But i think i need an Add Button for selections. For example;

Gender: Male

Firm: Firm 1

click to add button

Gender: Female

Firm: Firm 2

click to run report button.

[prieper]

Should work, but what is the desired output finally? Do you need to add them individually? Then you will have to go with combined boxes. If you wish to compare 2 results, you may choose alternate states.

Peter