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!