Line Chart

[#1]

Attached is a qlikview file with a line chart.

On the blue line, there is no data in some years. Can I hide the line segment without any data point? Thanks.

[#2]

In your example Comp1 has got values for all the years. So I'm not sure what you want to hide.

[#3]

The Comp1 has no value from 2008 to 2011. So, I want to hide this line segment. How to do it? Thanks for your reply.

[#4]

It may be possible. The only way I can think about it is using Set Analysis. Try the following

• Remove your "Comp" Dimension
• Remove your Sum(Score) Expression
• Add Two Expressions (to mimic the Comp Dimension)
  • =Sum ({<Comp={'Comp1'}>}Score)
  • =Sum ({<Comp={'Comp2'}>}Score)
• In the expressions Tab, expand Each Expression and Click Background Colour (click the "+" next to the expression in the top left corner of the Dialog Box)
  • I haven't quite worked it out yet, but something like IF(IsNull(Sum(score)), RGB(255,255,255)) could do the trick.

Someone cleverer than me, or with a bit more time, might be able to find out the exact formula you need for the background colour. I will see if I can have a look tonight and get it working