Only function

[Samanehsorournejad]

Hi every one,

I want to use Only function in order to show customer just the OrderID that they ShipDate is equal to OrderDate

I had try this :

Only({$<ShipDate=OrderDate>}OrderID)

it does not give me any error but does not show any OrderID (although there is some).

Please Guide me🤔

[brunobertels]

hi 

may be this 

Only({$<ShipDate={$(=OrderDate)}>}OrderID)

[Samanehsorournejad]

Hi,

unfortunately, it did not work too

😞

[MarcoWedel]

In what context would you apply this expression?

[Samanehsorournejad]

I have a table with some columns such as customer, OrderID, shipdate and orderdate. I had apply this expression for OrderID as measure.

I hope I had understand your question right

[SunilChauhan]

May be this

Only({$<ShipDate={"=OrderDate"}>}OrderID)

[MarcoWedel]

If there is only one ShipDate and OrderDate per OrderID, then one solution might be:

Only({$<OrderID={"=ShipDate=OrderDate"}>} OrderID)

In case you might have multiple shipments per order, then 

Only({$<OrderID={"=Min(ShipDate=OrderDate)"}>} OrderID)

should identify the Orders having shipments on the OrderDate.

Having a more granular ShipmentID for orders with multiple shipments, you could as well use

Only({$<ShipmentID={"=ShipDate=OrderDate"}>} OrderID)

hope this helps

Marco

[Samanehsorournejad · Accepted solution]

Hi Marco,

I had understand my fault, it works:

Only({$<OrderID={"=ShipDate=OrderDate"}>} OrderID)

😀

but is there any link or tutorial about this type of set analysis -?

Thanks a lot

[MarcoWedel · Accepted solution]

maybe this chapter about expression searches in set expressions might help:

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

please close your thread by accepting a solution if your question is answered.

thanks

Marco

[Samanehsorournejad]

thanks a lot I had do this