Image in Straight table problem

Tue, 29 Jul 2014 14:20:52 GMT

Hi all

I am using images in a straight table to give me a custom traffic light based on my own images.

The problem I am getting is this column is forcing a row to show even when the rows expressions are zero

Here's the expression:

=(if(($(eYTDActual(1))>0 and $(eYTDBudget(1)) <0) OR ($(eYTDActual(1))<0 and $(eYTDBudget(1)) >0),
if($(eYTDActual(1)) - $(eYTDBudget(1)) >0,Null(),'qmem://Warning/Red_Traffic'),

(if($(eYTDActual(1))=0 OR $(eYTDBudget(1))=0,
if($(eYTDActual(1))-$(eYTDBudget(1))<0,'qmem://Warning/Red_Traffic',Null()),
(if($(eYTDActual(1))>0,
if($(eYTDActual(1))/$(eYTDBudget(1))>=$(vUpperLimit),Null(),
if($(eYTDActual(1))/$(eYTDBudget(1))>=$(vLowerLimit),'qmem://Warning/Amber_Traffic',
if($(eYTDActual(1))/$(eYTDBudget(1))<$(vLowerLimit),'qmem://Warning/Red_Traffic'))),
if($(eYTDBudget(1))/$(eYTDActual(1))>=$(vUpperLimit),Null(),
if($(eYTDBudget(1))/$(eYTDActual(1))>=$(vLowerLimit),'qmem://Warning/Amber_Traffic',
if($(eYTDBudget(1))/$(eYTDActual(1))<$(vLowerLimit),'qmem://Warning/Red_Traffic')))))))

))

So the row will have a Null image and zero in the other expressions but still shows a row?

Please can anyone advise?

Thanks

Dominic

Re: Image in Straight table problem

Wed, 30 Jul 2014 10:47:21 GMT

I had left the Null()'s to possiblyt be replaced by a green traffic light - as soon as I removed these along with there respective if statements like:

=(if(($(eYTDActual(1))<=0 AND $(eYTDBudget(1))>=0) OR ($(eYTDActual(1))>=0 AND $(eYTDBudget(1))<=0) ,

if($(eYTDActual(1))-$(eYTDBudget($1))>0,'qmem://Warning/Red_Traffic'),

(if($(eYTDActual(1))>0,

if($(eYTDBudget(1))/$(eYTDActual(1))<$(vLowerLimit),'qmem://Warning/Red_Traffic',

if($(eYTDBudget(1))/$(eYTDActual(1))<=$(vUpperLimit),'qmem://Warning/Amber_Traffic'))

if($(eYTDActual(1))/$(eYTDBudget(1))<=$(vLowerLimit),'qmem://Warning/Red_Traffic',

if($(eYTDActual(1))/$(eYTDBudget(1))<=$(vUpperLimit),'qmem://Warning/Amber_Traffic'))

))))

it worked.

Cheers

topic Re: Image in Straight table problem in QlikView

Image in Straight table problem

Re: Image in Straight table problem