Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

Re: Similar to the function formula Vlookup

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.

Highlighted
Contributor III
Contributor III

Re: Similar to the function formula Vlookup

I am attaching the file

Highlighted
Master
Master

Re: Similar to the function formula Vlookup

Hi Steven,

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

Highlighted
Contributor III
Contributor III

Re: Similar to the function formula Vlookup

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

Highlighted
Contributor III
Contributor III

Re: Similar to the function formula Vlookup

any idea for this, please

Highlighted
Specialist III
Specialist III

Re: Similar to the function formula Vlookup

you can use this

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