topic Re: Supress specific line in chart in QlikView

Supress specific line in chart

Anonymous — Fri, 27 May 2011 10:09:16 GMT

Hi,

I have a line chart with four lines in it: Sales 2010, Sales 2011, Target 2011, Forecast 2011.

Is it possible to supress the Forecast line when a specific product is selected?

So, usually I would like all the lines but when making a selection on product I only would like to see the sales and target lines.

Kind regards,

Henco

Re: Supress specific line in chart

IAMDV — Fri, 27 May 2011 10:36:22 GMT

hencovanee - Yes, this is possible. I am assuming that you want to hide the trend line when you say "Surpress". Please correct me if this is not what you need.

Please select the expression (Forecast 2001) in your case. Then expand on the "+" plus sign and you can see Line Sytle option. You can select the Line Style option and then write the expression. In your case you can use the logic something like this...

IF(getselectedcount(Product) =0, [Your Preferred Color], RGB(255,255,255))

RGB(255,255,255) means white color. So when there is selection on the products the line color changes to white or else it shows your preferred color.

I am also attaching a screenshot for your reference

Hope this helps!

Cheers - DV

Re: Supress specific line in chart

Anonymous — Fri, 27 May 2011 11:13:33 GMT

Ah, thank you very much DV. That will work.

Henco

Re: Supress specific line in chart

IAMDV — Fri, 27 May 2011 11:24:24 GMT

Excellent! I am glad that it works. Please can you mark the post answered/helpful?

Cheers - DV