2 Replies Latest reply: May 30, 2017 12:50 PM by Thomas Lam RSS

    Qlik Sense - Set analysis with Multiple Variable

    Thomas Lam

      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