topic Re: conditionally hide/show line on chart based on x-value in QlikView

conditionally hide/show line on chart based on x-value

kmstephenson — Wed, 17 Aug 2016 14:40:42 GMT

Hi All,

I would like to only show the line on a combo chart for x-values -12 to -1, and subsequently from 1 to 12. I do not want a line from -1 to 1. How can I do this? The chart is technically not continuous because I have no 0 values, but I am setting the x-axis to continuous to show 0 on the chart. See below - no data point at 0, and do not want the line drawn from -1 to 1.

I currently have the line style set: IF(month_num<-1,'<S2><W0>',IF(month_num>=1,'<S2><W0>'))

Is there any style for no line?

Thanks!!

Re: conditionally hide/show line on chart based on x-value

vishsaggi — Wed, 17 Aug 2016 14:48:07 GMT

May be use the expression in the background and change it to white()

IF(month_num > -1, White(),IF(month_num <=1, White() ))

Try this/.

Re: conditionally hide/show line on chart based on x-value

kmstephenson — Wed, 17 Aug 2016 14:57:09 GMT

The problem is it looks like the line appears to be drawn with the data point prior --- so I need to set month_num=-1 to WHITE for the line to disappear, but that also makes the data point at -1 disappear....

Re: conditionally hide/show line on chart based on x-value

kmstephenson — Wed, 17 Aug 2016 14:59:45 GMT

I just created two separate expressions that are the exact same - one for the line, and one for the symbols and this worked!

Re: conditionally hide/show line on chart based on x-value

vishsaggi — Wed, 17 Aug 2016 15:12:03 GMT

Glad it worked. I just gave the expression for you to try how it looks as I do not have the sample app to tweak around.

Good work.

Re: conditionally hide/show line on chart based on x-value

kmstephenson — Wed, 17 Aug 2016 15:14:46 GMT

Thank you! I had been playing around with the background color and line styles but had used the same expression for both the symbol and line - your response helped me realize I needed to copy the expression and have one for the line and one for the symbol! Thanks again!!

Re: conditionally hide/show line on chart based on x-value

vishsaggi — Wed, 17 Aug 2016 15:15:26 GMT

Please mark the answers with helpful/correct so that other members will benefit. 🙂