how do i AGGR this string?

amien — Mon, 02 Nov 2009 01:58:40 GMT

Amien Team045

Amien Team556

i need this pivot

1 dimension 2 expressions:

Amien Team045 Team556

AGGR must be on a wildcard match on 045 and 556 .. not on full string.

johnw — Tue, 03 Nov 2009 05:29:25 GMT

I'm not sure if I understand the question, but if I do, one approach is just two expressions:

sum(if(wildmatch(Team,'*045*'),whatever))
sum(if(wildmatch(Team,'*556*'),whatever))

Another would be to add a synthetic dimension across the top (exclude null):

if(wildmatch(Team,'*045*'),'Team045'
,if(wildmatch(Team,'*556*'),'Team556'))

And then just have sum(whatever) as the expression. Replace "sum()" and "whatever" with whatever expression you actually wanted.

topic how do i AGGR this string? in QlikView