topic Re: Color code condition in QlikView

Color code condition

Anonymous — Thu, 17 Nov 2016 16:48:06 GMT

Document Received	Priority	Status
06 May 2016	Medium	Closed
07 April 2016	High	Open
07 April 2016	High	Closed
06 May 2016	Medium	Open

I want

1)if the priority is high and document received (current date- date received) is more than 4 months, status is open then it is coming on red

2)if the priority is medium and document received (current date- date received) is more than 10 months, status is open then it is coming on red

3) if the priority is high and status is closed then it is coming on green

4)if the priority is medium and status is closed then it is coming on green

Re: Color code condition

johnw — Thu, 17 Nov 2016 17:14:12 GMT

Maybe this?

if(Status='Closed',green()
,if(Priority='High' and today() > addmonths([Document Received],4),red()
,if(Priority='Medium' and today() > addmonths([Document Recieved],10),red())))

Re: Color code condition

Anonymous — Thu, 17 Nov 2016 17:22:25 GMT

if(Status = 'Closed',

green(),

if(Priority = 'High' and [Document Received] < AddMonths(Today(),-4) and Status = 'Open',

red(),

if(Priority = 'Medium' and [Document Received] < AddMonths(Today(),-10) and Status = 'Open',

red())))