Interval Function in Qlikview Script

[dunnalahk123]

HI,

Can some one guide me why my below function is not working as expected.

i have one project for that project  i have 4 time stamps

[Project Closure date]--This has date

[Project Creation Date]--This has date

[Project HOLD date]-- no date

[Project HOLD date2]--no date

so when i write below expression in Qlikview script, if i give only first condition which has dates it gives me result in Days  but if i give entire expression its not giving me any results

=((Interval(Date(([Project Closure date]-[Project Creation Date]),'MM/DD/YYYY'), 'DD'))

- ( Interval(Date(([Project HOLD date]-[Project HOLD date2]),'MM/DD/YYYY'), 'DD'))

)

for more details please find the attachment.

Best Regards,

Hari

[Anonymous · Accepted solution]

Hello, dunnalahk123!

Try this expression:

=Interval(Date(([Project Closure date]-[Project Creation Date]),'MM/DD/YYYY'), 'DD')

- IF(IsNull([Project HOLD date]-[Project HOLD date2]), 0,

Interval(Date(([Project HOLD date]-[Project HOLD date2]),'MM/DD/YYYY'), 'DD'))

[dunnalahk123]

HI Rodrigues,

Yes, thank you so much . it worked.

in b\w i tried using this

=((Interval(Date(([Project Closure date]-[Project Creation Date]),'MM/DD/YYYY'), 'DD'))

- IF(( Interval(Date(([Project HOLD date]-[Project HOLD date2]),'MM/DD/YYYY'), 'DD'))>='0' OR ( Interval(Date(([Project HOLD date]-[Project HOLD date2]),'MM/DD/YYYY'), 'DD'))<='0'

,( Interval(Date(([Project HOLD date]-[Project HOLD date2]),'MM/DD/YYYY'), 'DD')),'0')

)

it also worked.

Best Regards,

Hari