I want to keep the green, yellow, and pink lines as they are because their values are NULL before '01', '04', and '07', respectively. (the dimension ordering is correct! please don't mind the irregularity) but I want to show that the red line becomes zero after '11' and continues being zero!
"Suppress when value is null" and "Suppress zero values" are checked. when I uncheck "Suppress zero values" I get this result:
so the problem is that QV treats the NULL values as Zeros. How can I prevent this from happening? How can I show when the red line (with actual zero values in the data) is zero but not show zeros when the values of other lines (with NULL values in the data) are missing?