Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

query converting from sql into qlikview script

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

1 Reply
sunny_talwar

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')
)