topic Re: Interval Function in Qlikview Script in QlikView

Interval Function in Qlikview Script

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Interval Function in Qlikview Script

Anonymous — Wed, 20 Jun 2018 13:32:51 GMT

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

Re: Interval Function in Qlikview Script

dunnalahk123 — Wed, 20 Jun 2018 13:36:18 GMT

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