topic Re: colour by expression with date match qlik sense in App Development

colour by expression with date match qlik sense

joeybird — Mon, 05 Mar 2018 14:47:01 GMT

I am using qlik sense

I have a table that has

ID, Date, DepartmentCode, Status

Note: Date is max(Date)

I wish to colour by expression the date column if anyone in the last 3 months places an order for an inactive department.

I have tried this

if (Max(Date) = AddMonths(Max(Date), -0) and Status = 'Inactive', Red(),

if (Max(Date) = AddMonths(Max(Date), -1) and Status = 'Inactive', Yellow(),

if (Max(Date) = AddMonths(Max(Date), -2) and Status = 'Inactive', Green(), white())))

with no joy

please help

sunny_talwar — Mon, 05 Mar 2018 14:52:39 GMT

May be this

if (Max(Date) = AddMonths(Max(TOTAL Date), -0) and Status = 'Inactive', Red(),

if (Max(Date) = AddMonths(Max(TOTAL Date), -1) and Status = 'Inactive', Yellow(),

if (Max(Date) = AddMonths(Max(TOTAL Date), -2) and Status = 'Inactive', Green(), white())))

joeybird — Mon, 05 Mar 2018 15:27:49 GMT

brill thank you again

got close but not 'totally' close enough lol

Kind Regards