topic Re: Restricting values displayed in QlikView

Restricting values displayed

devans_1 — Fri, 27 Jul 2012 19:00:44 GMT

Does anyone know of a way of restrict values displayed ?

I have an expression (not dimension) that displays fields in colours, red or green using a formula on the background option. Whereas this works ok, I want to be able to display just the red fields. Is there a way of doing this ? It's difficult to change this to a dimension since the expression is a complex calculation and references other columns. It's such an easy requirement yet I just can't figure an easy way of doing it.

Any guidance would be appreciated.

Re: Restricting values displayed

robertomontanar — Sat, 28 Jul 2012 09:22:13 GMT

A creazy suggestion: put the "text color" to the backgroud color (es.: rgb(255,255,255) )

Re: Restricting values displayed

swuehl — Sat, 28 Jul 2012 15:19:38 GMT

In general, you can suppress lines in a table chart where all expressions return zero or NULL for that line (there is an option for that on presentation tab in chart properties, enabled by default).

So you basically only need to create expressions that return zero for the lines that you don't want to show.

Having said this, this could get quite complicated if your expressions are depending on each other (referencing other expressions by their labels).

Could you maybe post a small sample app that demonstrates your chart and expressions?