topic Legend contains gray items in QlikView

Legend contains gray items

Thu, 31 Mar 2011 16:17:10 GMT

Hi all,

Mmm.. For some reason the legend contains 'gray items' (see attached picture).

I use the transparent trick to make parts of my graph hidden. This works for one line but for multiple lines, only the first one gets a nice color in the refence. The others remain grey.

This is the formula I'm using. So if there are not enough questions I don't want to plot anything for that data point. This works OK, but the problem is that the legend shows gray (transparent) items instead of the corresponding color.

This is the formula I use on the Background color:

If(Count(Distinct Questionnaire_number)<100,ARGB(0,0,0,0),ColorMapJet(RowNo()))

Thank you all..

I already used the forum a lot and hopefully (since I'm a beginner) will start posting solutions soon..

Arjan Onwezen

Legend contains gray items

Thu, 31 Mar 2011 16:54:41 GMT

Use a calculated dimension to prevent the display of Hauls < 100

If(Count(Distinct Questionnaire_number)<100,Haul)

Legend contains gray items

Fri, 08 Apr 2011 09:45:06 GMT

Hi cisco_kid,

Thanks for the answer! However I get an error using that formula.

Perhaps it's because I use a calculated expression. I use the following expression.

Sum(Satisfaction_Score)/Sum(pond)

Hopefully you (or someone else) can help me.

Legend contains gray items

Mon, 11 Apr 2011 21:15:22 GMT

Use the formula as a Dimension not as expression.

Legend contains gray items

Miguel_Angel_Baeyens — Tue, 12 Apr 2011 04:47:51 GMT

Hello Arjan,

When you use colors in your expressions, and when one of the possible colors is "transparent" as it is in your chart, should any value has a "transparent" drawing, the legend takes that color, meaning "there are values I'm representing as transparent, since transparent it's not a color, I'lll display the legend grey".

Once that expression has one value greater than or equal to 100, then the legend will take the color stated in the else part of your condition.

Hope that helps.

Legend contains gray items

Tue, 12 Apr 2011 11:02:01 GMT

Thank you all for responding..

Hi Miguel. Yes I noticed that the boxes become gray once it reaches that value.. 😞

I now try a different alternative.That is a just showing the measures as dots and then either a trendline or a line connecting the dots.

Anyway thank you all for the comments.

Best regards,

Arjan Onwezen

Legend contains gray items

siva_boggarapu — Tue, 12 Apr 2011 11:11:21 GMT

Hi,

Crate some varibales and call those varibles. Like

$(vDFTDolphinColor) .