Help required to tackle this scenario in the charts

[qlikviewforum]

I have 3 metrics in a line chart. Lets say the metrics name is B,S and E. Lets assume that values for B and S is NULL from 01-APR-2016 to 15-APR-2016(Some value exists for E for this date range).  Since E has some value, there is flat line for B and S from 01-APR-2016 to 15-APR-2016 in the line chart.

But what the business needs is since there is no data available for 01-APR-2016 to 15-APR-2016 for B and S, there should be be any flat line from 01-APR-2016 to 15-APR-2016 in the line chart(In fact this is required in all the charts).One way of doing this is Suppress-Zero Values, but I don't want to do this since it will impact other functionality in the chart. Is there is any way to tackle this in UI or in the backend?

Can someone help me on this please?

[vinieme12]

have you tried checking Continuous  in the Axes tab?

[qlikviewforum]

Thanks for your response.

Yes already tried it but it is not working.

[vinieme12]

silly but add another condition to your line color expression and set ARGB(0,255,255,255) if value is 0 or null() !

[qlikviewforum]

This option was there in mind but I need some other option.