topic Set Analysis and Fields (and eventually wildmatch!) in QlikView

Set Analysis and Fields (and eventually wildmatch!)

Dayna — Thu, 13 Oct 2011 14:06:24 GMT

Hello All,

I'm sure this is an easy one, but I'm struggling! What I want to do is a set analysis expression where if EXPR1 = 1 and pt_part_type = ps_part_type, sum some results.

Eventually, I'd like to put something like a wildmatch in, so it looks at the left 3 characters of pt_part_type and compares it with the 3 left characters of ps_part_type, but baby steps..

I thought it would be something like this:

sum({$<tr_type = {'ISS-WO'},EXPR1 = {'1'},pt_part_type=ps_sub_part_type >} value)

But it only brings back a result when I've select the ps_sub_part_type that it would be applicable to... Anyone have any ideas?

Many thanks for any help you can provide!

Kind Regards,

Dayna

Set Analysis and Fields (and eventually wildmatch!)

swuehl — Thu, 13 Oct 2011 14:10:41 GMT

Hi,

to assign also the possible values, try the p() function:

sum({$<tr_type = {'ISS-WO'},EXPR1 = {'1'},pt_part_type= p(ps_sub_part_type) >} value)

Regards,

Stefan

Re: Set Analysis and Fields (and eventually wildmatch!)

Dayna — Thu, 13 Oct 2011 14:32:04 GMT

I don't think it's worked, I might be wrong but to test it I'm summing a value that should only have one (where part type = r25).

Please see attached..

Kind Regards,

Dayna

Re: Set Analysis and Fields (and eventually wildmatch!)

swuehl — Thu, 13 Oct 2011 14:38:50 GMT

Ah, you want to limit ps_sub_part_type, then?

sum({$<tr_type = {'ISS-WO'},EXPR1 = {'1'},ps_sub_part_type= p(pt_part_type) >} value)

Re: Set Analysis and Fields (and eventually wildmatch!)

Dayna — Thu, 13 Oct 2011 15:43:11 GMT

Thank you!!