Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
CASE
WHEN
[Alternate Resolution Date(UTC/GMT)] IS NULL
THEN
(
CASE WHEN _days_between(current_timestamp,[ Target Resolution Date(UTC/GMT)]) > 0 THEN 'Y' ELSE 'N' END
)
WHEN
[Alternate Resolution Date(UTC/GMT)] IS NOT NULL
THEN
(
CASE WHEN _days_between(current_timestamp,[ Alternate Resolution Date(UTC/GMT)]) > 0 THEN 'Y' ELSE 'N'
END
)
END
Cananyoneplease help me in qlikview script in if condition
May be this
If(Len(Trim([Alternate Resolution Date(UTC/GMT)])) = 0,
If(current_timestamp - [ Target Resolution Date(UTC/GMT)] > 0, 'Y', 'N'),
If(current_timestamp - [ Alternate Resolution Date(UTC/GMT)]) > 0, 'Y', 'N')
)