topic General Formatting query. in QlikView

General Formatting query.

Thu, 28 Jul 2011 14:12:14 GMT

Hello All,

I am trying a simple background colour expression, which doesnt seem to be working and hope someone could help me with it.

=if("=$[KPI_Conduit]">1, LIGHTGREEN(),WHITE())

I have a straight table on which I have a KPI_Conduit as a Dimension, I want the row to be highlighted when the user clicks on any field under the KPI_Conduit in the straight table. This expression is working to some extent, but when I clear All then all the fields turn Green...

Thanks,

Mady

General Formatting query.

lironbaram — Thu, 28 Jul 2011 14:15:14 GMT

hei try

if(getselectedcount(KPI_conduit)>0,lightgreen(),white())

General Formatting query.

Thu, 28 Jul 2011 14:22:26 GMT

Hello,

unfortunately its still turning the whole dimension field GREEN when I click on 1 field.But I think the expression is wrong as it turns everything light green because its >0 when you click on something.

Any more suggestions please I also tried :

if(getselectedcount(KPI_conduit)>0 and getselectedcount(KPI_conduit)<=1,lightgreen(),white())

Thanks in Advance,

Mady

General Formatting query.

lironbaram — Sun, 31 Jul 2011 06:16:46 GMT

hei mady

can you post example

i'll get better understanding of the problem

General Formatting query.

deepakk — Sun, 31 Jul 2011 08:55:11 GMT

hi,

Try this code.

if(getselectedcount(KPI_conduit) =1, lightgreen(),white())

Deepak