topic Double color for the table cell in QlikView

Double color for the table cell

Fri, 27 Apr 2012 14:02:58 GMT

Hi All,

i have a typical request, in the table cell i have to color it based on the condition, the cell value is calculated percentage of the current month so if the values is greater then 5% then the last year same month then its right half of the cell must be green if less the -5% then its must be red, if its between then its must be white, and then the same month value is compated with last month value and it is greater then 5% then the last year same month then its left half of the cell must be green if less the -5% then its must be red, if its between then its must be white, pfa pic for your reference, any help will be appreciated

Double color for the table cell

Fri, 27 Apr 2012 14:27:49 GMT

any ideas any one

Double color for the table cell

Fri, 27 Apr 2012 14:56:11 GMT

You could try this:

Create 2 tables. The first table has the cell type set as image as you use images to diaplay either full or half or white. The cells will not display any values. Then in the second table create a standard chart table with text values but set the cell background to be transparent. Overlay the second chart on the first.

Double color for the table cell

Mon, 30 Apr 2012 09:51:46 GMT

hi,

nice ideal, problem is that i have to represent it in single table only, any ideal any one

Double color for the table cell

Mon, 30 Apr 2012 10:01:09 GMT

To the user it would appear as only one table. There isn't any other way of doing it.

Double color for the table cell

Mon, 30 Apr 2012 11:46:42 GMT

but i am not able to put transparency in the cell background i am using QV 9 PE version and there is not option in it

wht i tried is i have given one condition as background and for other i am trying to dispaly as traffic light bt only one of them is coming not both of them