Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Reply
sunny_talwar
MVP
MVP

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