Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dan-ketil
Contributor II

Datefunction in interval

Hi

I have a formula where I compare two dates and if the interval is > 0 I want to dispaly the intveral

This consists of a createdate and a shippingdate.

The shipping date is a construction of two parameters.

I need to check if the real depaturetime is less then the esteimated one. If so it is actually sent the next day

This function seems to give the correct date.

=Date#(

        IF([Real shipdate] < [Est ship date ],

            DATE(DATE(WantedShippingDate)+1,'DD-MM-YYYY') & ' ' & TIME([Real shipdate ]),

            DATE(DATE(WantedShippingDate),'DD-MM-YYYY') & ' ' & TIME([Real shipdate]))

,'DD-MM-YYYY HH:MM:SS')

I orgiialy had a formula where I compared the two dates:

=IF(INTERVAL(max(MaxCreateDt1)-max(WantedShippingDate), 'mm:ss') > 0,INTERVAL(max(MaxCreateDt1)-max(WantedShippingDate), 'mm:ss') ,'-')

Now I have to change the  WantedShippingDate with the date expression above. But it results in blank...or rather the sign - .

=INTERVAL(max(MaxCreateDt1)-max(

                                                         Date#(

                                                                   IF([Real shipdate] < [Est ship date ],

                                                                        DATE(DATE(WantedShippingDate)+1,'DD-MM-YYYY') & ' ' & TIME([Real shipdate ]),

                                                                        DATE(DATE(WantedShippingDate),'DD-MM-YYYY') & ' ' & TIME([Real shipdate])),'DD-MM-YYYY HH:MM:SS')

                                                                     )//END IF

  , 'mm:ss')

Any comments?

BR

Dan

Tags (2)