Subtracting between dates and filtering

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

Hello All,

I have a DDBB table in which the columns are in the format as follows: YYYY-MM-DD HH:MM:SS.S for example 2020-02-28 10:23:50.240

Column A (Hora Peticion) is Timestamp for order and Column B is timestamp for delivery (HoraDescarga) . The delivery time is =interval(HoraDescarga-HoraPeticion)

My aim is to plot which values are above a certain time for example 00:10:00 - ten minutes and which are below this time. Ending up with a histogram as a result with "OK" values and "NOK" values for the total deliveries.

What expressions can i use inside the plot chart so it appears this way? I suppose one expression for "OK" and one for "NOK" . I manage to get the intervals with : =interval(HoraDescarga-HoraPeticion) but need to filter these results.

Thanks

Re: Subtracting between dates and filtering

rubenmarin — Wed, 08 Apr 2020 14:03:43 GMT

Hi, you can try with:

If(HoraDescarga-HoraPeticion<1/24/6, 'OK, 'NOK')

Re: Subtracting between dates and filtering

adelpor1 — Wed, 08 Apr 2020 14:39:03 GMT

Hi, thanks for the reply.

How would the count function work here?

topic Re: Subtracting between dates and filtering in QlikView

Subtracting between dates and filtering

Re: Subtracting between dates and filtering

Re: Subtracting between dates and filtering