Max Value

Fri, 21 Jul 2017 11:54:43 GMT

Hello All,

I've have a question for you, basically i have to reproduce the same query SQL in QlikSense:

Select

s.shipment_id,

s.request_id,

su.serial_id,

( select max(ru1.request_unit_id)

from request_unit ru1

where ru1.serial_id = su.serial_id

and ru1.created_dttm < su.created_dttm ) last_repaired_unit

from shipment s

, shipment_unit su

where 1 = 1

and s.shipment_id = su.shipment_id

and su.serial_id ='14277PP20385546'

and s.shipment_id='1505885'

result:

shipment_id request_id serial_id last_repaired_unit

1505885 167026 14277PP20385546 2103472

To be clear i have 2 table:

SHIPMENT_UNIT:

shipment_id

serial_id

REQUEST_UNIT

serial_id

request_unit_id

In this method i will have for one serial number more than one request_unit_id and i need only the max value of this filed.

Is possible to do that? thank You Massimiliano

topic Max Value in App Development