Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
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())))
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())))
Hi
brill thank you again
got close but not 'totally' close enough lol
Kind Regards