Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thomaslam
New Contributor

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
Esteemed Contributor

Re: Qlik Sense - Set analysis with Multiple Variable


Try:


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

thomaslam
New Contributor

Re: Qlik Sense - Set analysis with Multiple Variable

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