1 Reply Latest reply: Mar 16, 2018 4:16 PM by Siddharth Sheshadri RSS

    How to make a selective SUM (multiple columns) for a chart

    Alejandro Caro

      Hello everyone!

       

      I´m new at qlik so my questions may be very basic, but I guess we all started somehow similar   and iw worse not to ask.

       

      I have a table similar to this:

       

      Captura de pantalla 2018-03-16 a la(s) 11.54.35.png

       

      If I want to sum the entire Value column I use:

       

      Sum(Value)

      (expected result: 254)


      If I want to sum Value for the Month 1 I use:


      Sum({<Month={1}>}Value)

      (expected result: 102)

       

      But, how do I sum Value for the Month 1 AND Broker BA ? 

      (expected result: 62)


      And how would it be to sum Value for month 1 AND Broker BA AND Stock A ?

      (expected result: 10)


      THANK YOU SO MUCH IN ADVANCE!

       

      PS: Im using qlik sense cloud