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

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

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!