8 Replies Latest reply: Mar 16, 2018 3:27 PM by Jahanzeb Hashmi RSS

    How to make a selective SUM for a chart

    Alejandro Caro

      Hello everyone!

       

      I´ll be probably making a very basic and silly question, but Im new

       

      I have a table similar to this:

       

      Captura de pantalla 2018-03-15 a la(s) 14.24.43.png

       

      I want to make a pie chart to show how much dollars are per broker in a specific month.

       

      In dimension I set the broker

       

      In measure, if I use sum(value) it sums all the values, giving me always the following:

       

      Broker A: 62

      Broker B: 51

       

      My expected result would be that if I create a chart for month 1 get the following values in the chart:

       

      Broker A: 30

      Broker B: 30

       

      How do I make some kind of conditional SUM? (sum only when month equals 1) or there is another way?

       

      THANK YOU SO MUCH IN ADVANCE!

       

      PS: Im using qlik sense cloud