Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

stvn_003
New Contributor II

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
Valued Contributor 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.

stvn_003
New Contributor II

Re: Similar to the function formula Vlookup

I am attaching the file

Siva_Sankar
Honored Contributor

Re: Similar to the function formula Vlookup

Hi Steven,

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

stvn_003
New Contributor II

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

stvn_003
New Contributor II

Re: Similar to the function formula Vlookup

any idea for this, please

ramoncova06
Valued Contributor III

Re: Similar to the function formula Vlookup

you can use this

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

Community Browser