Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stvn_003
Contributor III
Contributor III

Similar to the function formula Vlookup

The tenth column of the second table is the last No. SO, what I want is that in the last column the price of the last sales order that is marked in the first table also appears.

Says 17.91, should read 16.66

Sin título.jpg

6 Replies
danieloberbilli
Specialist II
Specialist II

It can't be done by looking up a cell in another (straight/pivot) table object, but can be done by set analysis. What we need to know/understand are the logical tables in the background (data fields and tables involved) and the dimensions / expressions of your table objects.

stvn_003
Contributor III
Contributor III
Author

I am attaching the file

Siva_Sankar
Master II
Master II

Hi Steven,

use this expression.
find the attachment =Alt(min({$}ocd_iprnetsap),0)

stvn_003
Contributor III
Contributor III
Author

Thanks Siva, but that only works for this specific case, but there may be cases where it is higher, lower or middle

stvn_003
Contributor III
Contributor III
Author

any idea for this, please

ramoncova06
Specialist III
Specialist III

you can use this

only({< occ_nocedi = {"$(=MaxString({$<ocd_precio_ok = {N} >} (occ_nocedi)))"} >} ocd_iprnetsap)