topic Visual cues not working in QlikView

Visual cues not working

Wed, 04 Jul 2012 11:32:53 GMT

Hi all,

Hope you can help.

Within a straight table, we can change the backgroud of a cell based on 'Visual cues', great for highlighting ares of interest in a table. However, in each cell I don't just have a number (say field1) I also have a freq

=avg(field1)
=avg(field1) & '(' & count(field1) & ')'

From the above two expressions, I am able to use visual cues for the first but not the second.

Is there any way around this as I really want to include the freq within each cell.

Regards,

Revlin

Re: Visual cues not working

swuehl — Wed, 04 Jul 2012 11:39:37 GMT

Visual cues only work with expression that return numericals. Your second expression is returning a string.

But you can use a background color attribute expression (click on the small plus sign next to your expression in expression tab) and enter as defiition something like

=if(avg(field1) < 0, lightred() )

i.e. you must create an expression that returns a color (can also be created using rgb() or argb() functions).

Hope this helps,

Stefan

Re: Visual cues not working

Wed, 04 Jul 2012 13:44:50 GMT

Thank you Stefan - this is exactlky what I was looking for.

Regards

Revlin