Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.
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.
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