Hello Qlikers,
I'm having some troubles with my Sankey chart, that I'm using to show the Actual vs Budget sales.
If you see field A, in pict1 the total value is -7.9, but in dimension B, the sum won't add up. I exported the data, and found that negative comes from a combination of B4, C3. As you can see, B4 isn't displayed, not even when I just filter by C3 (pict2 ). If I manually filter B4 with the filter panes, the chart appears empty (image not attached).
How can I work around this? I don't see why I can have negative values in Dimension C, but not on dimension B.
Thank you!
