topic Re: before Function in QlikView

before Function

darrellbutler — Fri, 17 Aug 2012 09:46:51 GMT

Hi,

I'm trying to highlight values in a table that are less than the previous day. My horizontal dimension is date however the following doesn't seem to work

if(columnno()>0 and rowno()>0,if(before([CONFIRMED_FORECAST_TONNES],1,0)<[CONFIRMED_FORECAST_TONNES],rgb(255,198,198),rgb(198,255,198)),rgb(255,255,255))

any ideas why this maybe the case ?

rgds

Darrell.

Re: before Function

rajni_batra — Fri, 17 Aug 2012 09:53:46 GMT

TRY

if(columnno()>0 and rowno()>0,if([CONFIRMED_FORECAST_TONNES]<previous([CONFIRMED_FORECAST_TONNES]),rgb(255,198,198),rgb(198,255,198)),rgb(255,255,255))

Re: before Function

Fri, 17 Aug 2012 11:14:40 GMT

take this. BYE