Set analysis; use Field as Filter

[#1]

hi,

iam a rookie. in set Analysis, i often use them but useally copy and past or with help of the Toolbox.

i'm looking for for the Syntax or possibility to use a field as filter in a set Analysis Expression.

iam trying like this

Only({$<"VendorNo"="b-VendorNo">}"Price")

the 2 VendorNo. are 2 different fields in 2 different Tables. i want the "Price" where the 2 fields are matching.

there is already a Key between a the VendotNo and a "a-VendorNo"

now i want to list the Price of the B-Vendor in the same list.

hope my bad english dont scare you away...

[arsal_90]

can u share demy qvw with the 2 table

[#3]

oh not right now, have to cute the tables before..too big, and i have to mask/edit Data a bit....   .think i will edit the table so i can send tommorow...(18:40 right now here)

[#4]

iam trying with this Funktion it seem that some other value still causing that cant see all but where i see them the are correct. think the Problem is mostly resolve. i thank a lot

[arsal_90]

Can u just make that table in excel (with 5 to 10 records)

that 2 table that u discussed and also mention what result would u expect from that table