Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Subtracting between dates and filtering

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 

2 Replies
Highlighted

Re: Subtracting between dates and filtering

Hi, you can try with:

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

Highlighted
Contributor
Contributor

Re: Subtracting between dates and filtering

Hi, thanks for the reply. 

 

How would the count function work here?