topic Re: IF condition in QlikView

IF condition

Tue, 01 Mar 2016 11:08:12 GMT

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.

Re: IF condition

sunny_talwar — Tue, 01 Mar 2016 11:12:38 GMT

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

Re: IF condition

t_chetirbok — Tue, 01 Mar 2016 11:13:18 GMT

Hello!

Your condition will return 'Not Yet Due' or NULL

Re: IF condition

tresB — Tue, 01 Mar 2016 11:15:31 GMT

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

Re: IF condition

Anonymous — Tue, 01 Mar 2016 11:17:08 GMT

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

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

Re: IF condition

Tue, 01 Mar 2016 11:34:58 GMT

Hi to All,

i am very happy for your replies and thanks.

Can you please explain me each step dont mine.

regards

prathap.

Re: IF condition

t_chetirbok — Tue, 01 Mar 2016 11:58:37 GMT

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'

Re: IF condition

Anonymous — Tue, 01 Mar 2016 11:59:03 GMT

check this for basic learning?

If Statements in C - Cprogramming.com

if...else statement in C

IF & Else condition

Re: IF condition

Tue, 01 Mar 2016 12:07:24 GMT

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?

Re: IF condition

Peter_Cammaert — Tue, 01 Mar 2016 15:23:47 GMT

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]

Re: IF condition

t_chetirbok — Tue, 01 Mar 2016 15:28:00 GMT

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