topic Re: Conditional Background Colors in List Box Cells in QlikView

Conditional Background Colors in List Box Cells

Wed, 19 Mar 2014 20:45:09 GMT

I need to display the ~650 values of one field on a single screen with no scrolling, so I'm pretty sure I can only use a listbox with multiple columns. That being said, I have to indicate three different conditions on the listbox following this logic:

if

(ALIVE='yes' and PARA_VALUE='INSYNCH' or ALIVE='yes' and IsNull(PARA_VALUE),RGB(255,0,0),

if(ALIVE='yes' and PARA_VALUE='NOTINSYNCH',RGB(0,255,0),

if(ALIVE='no',RGB(0,0,255))))

I tried using an additional expression with traffic light gauge but that didn't come out as we needed. I tried implementing this expression in the Presentation\Background\Conditional Color script entry area but nothing happened. Help!

Re: Conditional Background Colors in List Box Cells

Wed, 19 Mar 2014 21:00:47 GMT

I believe your exact requirement cant be met, but how about like in the attached.
Create three separate list boxes(using list box expressions) with different Caption colors.

Re: Conditional Background Colors in List Box Cells

Thu, 20 Mar 2014 14:23:09 GMT

This won't help, since I have text strings. Also, there will be additions to the field as time goes on. Is there a way in a chart to display only a certain "chunk" of fields? Like the first chart would display only records 1-53, the second chart would display records 54-106, etc?

I have tried conditional formatting using the Calculated Base Color but that seems to be broken on list boxes, since something like

=if(SUSTAIN='yes',Green())

does nothing.

Re: Conditional Background Colors in List Box Cells

ThornOfCrowns — Thu, 20 Mar 2014 14:30:31 GMT

You can use RANK and AGGR to 'chunk' the data.

Re: Conditional Background Colors in List Box Cells

Thu, 20 Mar 2014 14:46:12 GMT

Can you attach a sample file. I think Chunk of data is possible even if the list expands. Mine was just an example. Instead of hard coding the expression you can make it dynamic per needs.

Re: Conditional Background Colors in List Box Cells

ThornOfCrowns — Thu, 20 Mar 2014 14:48:57 GMT

Have a look here: http://www.avitsland.com/2010/08/qlikview-dynamic-columns-in-chart-straight-table/ for an example of dynamically building a straight table. You could use this and then play about with the backgroaund colour values, perhaps?

Re: Re: Conditional Background Colors in List Box Cells

Mon, 24 Mar 2014 13:30:48 GMT

That web page seems to be down, James. Currently I'm playing around to see if there's any chart type that can legibly display all 600 something values. I've attached a simple example of the data and what I need to accomplish.It would be ideal if I could have conditional formatting for the cell backgrounds instead of having to rely on an expression column.