topic Hide some values in the graph. in QlikView

Hide some values in the graph.

Fri, 08 Apr 2011 13:07:37 GMT

Hi there,

I would like to 'hide' some values in a graph.

I tried using 'suppress zero-values'. However when I mark that value, the corresponding month is skipped.

However when I unmark that value (see below) the graph interpolates the points.

What I would like is to not display the line between month 3 and month 5.

I use the following expression definition:

If(Count(Distinct Nbr_Questions)>100,Sum(Satisfaction_Score)/Sum(pond))

I also tried to hide the line under the expression background color. However it's not really working, since that will always create a line in stead of a dot, while only one value (month) is > 100. Also then the legend will turn grey.

Hopefully someone can help tackle this problem.

Best regards,

Arjan Onwezen

Hide some values in the graph.

Anonymous — Mon, 11 Apr 2011 01:15:01 GMT

Checking the "Invisible" box on the Expressions Tab of your Chart Properties can make an individual expression's line not appear. This may not solve the problem straightaway, but it could provide some insight.

Hide some values in the graph.

Mon, 11 Apr 2011 07:02:13 GMT

Hi,

May be you can try set analysis in your expression to ignore those particular months you want to hide incase your dimension is a drilldown(Year-Month-Weekday). Not very sure about it but you may try the expression:

If(Count(Distinct Nbr_Questions)>100,Sum({$<Month-={Mar,Apr,May}>}Satisfaction_Score)/Sum({$<Month-={Mar,Apr,May}>}pond))

This would display a line direct from second month to sixth month in the chart. Try if it works.

This is just a suggestion as per my understanding of your query, experts please correct incase wrong.

Thanks.