Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense - Set analysis with Multiple Variable

Hi there,

First time in the community and trying to setup a set analysis with multiple variable, but not having much luck. Wonder if someone can provide some help.

I am trying to sum Quantity based on Record type "Sales" but would want the analysis to exclude selection of Customer.

Below is what i have, but it doesn't seem to work as it is ignoring the "customer" exclusion.

=sum({<Customer=>}{$<RecordType={'Sales'}>}Quantity)

Please let me know if anyone has some suggestion.

Thanks,

Thomas

2 Replies
OmarBenSalem


Try:


sum({<Customer=,RecordType={'Sales'}>}Quantity)

Anonymous
Not applicable
Author

Thank you very much. It works!!!!!