topic Re: Set analysis; use Field as Filter in QlikView

Set analysis; use Field as Filter

Mon, 17 Mar 2014 16:42:44 GMT

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

Re: Set analysis; use Field as Filter

giakoum — Mon, 17 Mar 2014 16:46:14 GMT

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

Re: Set analysis; use Field as Filter

MK_QSL — Mon, 17 Mar 2014 16:47:11 GMT

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

Re: Set analysis; use Field as Filter

PrashantSangle — Mon, 17 Mar 2014 16:47:26 GMT

Hi,

Try this

Sum({<VendorNo={B-VendorNo}>}Price)

Re: Set analysis; use Field as Filter

jvitantonio — Mon, 17 Mar 2014 16:47:47 GMT

Hello Hien,

Put this as a Dimension like:

=If([VendorNo]=[b-VendorNo], [b-VendorNo])

And in your expression use:

=sum(Price)

Re: Set analysis; use Field as Filter

alexandros17 — Mon, 17 Mar 2014 16:48:24 GMT

Unfortunately you cannot compare 2 fields in set analysys but you may compare a field and a value or a rage of values;

so you may write field1 = {'$(=max(field2))'} but you cannot field1 = {field2}

Re: Set analysis; use Field as Filter

jerem1234 — Mon, 17 Mar 2014 17:06:28 GMT

You may be able to get away with the p() function.

Only({$<VendorNo=p([b-VendorNo])>}Price)

Hope this helps!

Re: Set analysis; use Field as Filter

Mon, 17 Mar 2014 17:08:14 GMT

thank for replies.

i tried all. but didnt work.

now i trying to use the max-Expression like allesandro wrote. the VendorNo r all 5-digits Numbers so ...should work?

Re: Set analysis; use Field as Filter

giakoum — Mon, 17 Mar 2014 17:09:43 GMT

you better post a sample application, otherwise this may go on for ever

Re: Set analysis; use Field as Filter

Mon, 17 Mar 2014 17:29:17 GMT

hope this help..

first list got the Artikel.no. the main-vendor and the alternativ-vendor

second list got the Price of all vendors.

the are already linked with the main-vendor. and Artikel.no.

iam looking for a way to Show them in one list:

Artikelnr. Kreditornr. Ek-Preis A-Kreditornr. Ek-Preis

1062407 730189 62,14€ 970279 109,09€

Re: Set analysis; use Field as Filter

arsal_90 — Mon, 17 Mar 2014 17:35:43 GMT

can u share demy qvw with the 2 table

Re: Set analysis; use Field as Filter

Mon, 17 Mar 2014 17:45:07 GMT

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)

Re: Set analysis; use Field as Filter

Mon, 17 Mar 2014 17:55:07 GMT

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

Re: Set analysis; use Field as Filter

arsal_90 — Mon, 17 Mar 2014 18:09:43 GMT

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