topic Visual cues in table using set analysis in QlikView

Visual cues in table using set analysis

Jason_Michaelides — Mon, 06 Dec 2010 13:21:24 GMT

Hi all,

This feels really simple so I'm not sure at all why it's not working for me!

I have 3 main tables:

As you can see, CostCentre is the linking field. I have created a simple straight table chart showing the spend this period against last period for each Company (Tree table):

Expression for Spend this period is

=SUM(Amount)

Expression for Spend previous period is

SUM( {$<Period = {$(#vPreviousPeriod)}>} Amount )

The figures in the chart are accurate so the set analysis is working OK. All I want to do is have the value of this period in red if it is higher than last period and green if it's less than or equal to last period. Shouldn't be difficult! I have gone to Visual Cues, selected the correct expression and added the set analysis formula into the Upper and Lower boxes:

But all the values are green as you can see in the chart image above!

Please help!!

Jason

Visual cues in table using set analysis

Mon, 06 Dec 2010 14:19:47 GMT

Hi Jason,

I won't use the Visual Cues. What I prefer is to affect the "Text Color" of an expression. You find it when expanding the [+] from your expression --> check text color --> edit expression similar to this:

if( [Spend this period] - [Spend previous period] > 0, lightgreen( ))

HtH

Roland

Visual cues in table using set analysis

kji — Mon, 06 Dec 2010 14:32:49 GMT

Visual cue expressions are evaluated on a global level, not on a row by row basis, to do that you should use the color subexpressions.

Visual cues in table using set analysis

Jason_Michaelides — Mon, 06 Dec 2010 15:09:40 GMT

Thank you both - worked a treat. I knew I was missing something simple...

Jason