topic Re: Only function in App Development

Only function

Samanehsorournejad — Fri, 01 Apr 2022 15:30:34 GMT

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🤔

Re: Only function

brunobertels — Fri, 01 Apr 2022 16:00:12 GMT

may be this

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

Re: Only function

Samanehsorournejad — Fri, 01 Apr 2022 16:36:31 GMT

Hi,

unfortunately, it did not work too

😞

Re: Only function

MarcoWedel — Fri, 01 Apr 2022 20:19:15 GMT

In what context would you apply this expression?

Re: Only function

Samanehsorournejad — Sat, 02 Apr 2022 07:27:17 GMT

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

Re: Only function

SunilChauhan — Sat, 02 Apr 2022 11:18:04 GMT

May be this

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

Re: Only function

MarcoWedel — Sat, 02 Apr 2022 13:24:39 GMT

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

Re: Only function

Samanehsorournejad — Sat, 02 Apr 2022 15:46:18 GMT

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

Re: Only function

MarcoWedel — Sat, 02 Apr 2022 16:53:09 GMT

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/SetAnalysis/set-modifiers-advanced-searches.htm#:~:text=field%20in%20question.-,Expression%20searches,-You%20can%20use

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

thanks

Marco

Re: Only function

Samanehsorournejad — Sat, 02 Apr 2022 18:20:18 GMT

thanks a lot I had do this