Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
sunny_talwar

If the conditions are met, you should get 'Not Yet Due', else you will have Null() for 3rd timestamp

t_chetirbok
Creator III
Creator III

Hello!

Your condition will return 'Not Yet Due' or NULL

tresesco
MVP
MVP

If the file is not yet received and fiscal week end time is less  than 24 hours ( a day) from the load time , the flag would be marked as 'Note Yet Due'.

Anonymous
Not applicable
Author

IF(Condition is True, 'if True, FirstStatmentTo Write', 'Else This Statment')

If we donot specify 'Else This Statment', it will take Null()

Not applicable
Author

Hi to All,

i am very happy for your replies and thanks.

Can you please explain me each step dont mine.

regards

prathap.

t_chetirbok
Creator III
Creator III

so

condition is IsNull(FileReceivedTimeStampPMCTTemp) and FiscalWeekEndDateTimeliness - now() >=Timestamp#('24:00:00','hh:mm:ss')

if it returns true your field will be 'Not Yet Due'

if it returns false your field will be 'NULL'

Anonymous
Not applicable
Author

Not applicable
Author

Hi

Is null(FileReceivedTimeStampPMCTTemp)----> what it will return.

now()>=Timestamp#('24:00:00','hh:mm:ss')----> what  it will return


i want to know what these are return.


can please explain me?


Peter_Cammaert
Partner - Champion III
Partner - Champion III

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


deconstruction into readable pseudo-code results in:


IF FileReceivedTimeStampPMCTTemp IS NULL  // Not yet received

   AND ( FiscalWeekEndDateTimeliness - now() ) >= 24 hours // more than 1 day to go

THEN

     put string "Not Yet Due" -> field [3rd timestamp]

ELSE

     put NULL -> field [3rd timestamp]