topic Re: Line Chart in QlikView

Line Chart

Wed, 17 Dec 2014 01:28:30 GMT

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.

Re: Line Chart

Wed, 17 Dec 2014 01:40:08 GMT

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

Re: Line Chart

Wed, 17 Dec 2014 02:11:47 GMT

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.

Re: Line Chart

Wed, 17 Dec 2014 02:42:13 GMT

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