0 Replies Latest reply: Oct 5, 2018 6:15 AM by Verónica Hernández RSS

    Sum only negative values of a column and display them in a graph

    Verónica Hernández

      Hello,

       

      I have calculated measures which result can be either positive, negative or 0. For example, the quantity I am going to have in the next 4 weeks of an article.

       

      For example,

       

      article        today      week1     week2     week3     week4

      1                 -3            -3            -3             -3            -3

      2                 -2            -2            -2              -2           -2

      3                -1              -1            15            15           15

      4                -5             -5             -5               20          20

       

       

       

      I want to know which week I need to buy what article. So I need to make a graph that show the sum of only the negative values. For example, for today: -3+-2+-1+-5=-11, on week 2: -3+-2+-5=-10, so when I click in the date today I can see that I need to buy 3 of article 1, 2 of article 2, 1 of article 3 and 5 of article 5.

       

       

      I am working in Qlik Sense.

       

      Thanks!