Don't show 0 values in line chart (CY sales, LY sales, Goal sales comparison)
Hi there everyone,
Again here I am with another Qlik related question. This time about line charts. The deal is I'm putting a line chart to compare this year's sales, this year's sales goal and the last year's sales. Sounds like a pretty basic idea, but when I put it together it looks like this.
My issue here is that I don't want "Sales CY $" and "Sales Goal $" to drop to zeros, I want them to stop at their current location. Something like this:
I already unchecked the zeros option in "Data Handling," but the zeros and the line going down won't disappear. Here are my measures:
Well, I feel really stupid now! Sometimes I think things are more complicated that they seem to be... But thanks a lot! Also, I had to turn that ">" into "<>" because there are some negative values. Again, thanks!