Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF condition

Hi All,

if(IsNull(FileReceivedTimeStampPMCTTemp) and FiscalWeekEndDateTimeliness-now()>=Timestamp#('24:00:00','hh:mm:ss'),'Not Yet Due') as [3rd timestamp],

FileReceivedTimeStampPMCTTemp  and   FiscalWeekEndDateTimeliness  ----> these two are the fields in my table.


If i run above IF condition what it willl rerurn ??


Please help me out this issue.


Thanks IN advance.





Regards

prathap.

10 Replies
t_chetirbok
Creator III
Creator III

isnull() function use to checking if the value is NULL, it returns TRUE if value is NULL and FALSE value is not NULL.

Timestamp# is function to transform value ('24:00:00') to needed format ('hh:mm:ss')

and your expression FiscalWeekEndDateTimeliness - now() returns TRUE if it >= 24 hours and FALSE if < 24 hours


and if both conditions are TRUE, your if statement returns TRUE