topic Transform match into set analysis in QlikView

Transform match into set analysis

timmy — Tue, 16 Feb 2010 10:36:09 GMT

Hey

Can somebody help me to transform this function into a set analysis?

Match

tnx

Timmy

(Dos_StatusId,1002,1050)<>0

Miguel_Angel_Baeyens — Tue, 16 Feb 2010 11:01:53 GMT

Sorry for the double post.

Miguel_Angel_Baeyens — Tue, 16 Feb 2010 11:02:13 GMT

Hello Timmy,

If I get you right, you want to check one field to one or more values in set analysis, in this case, finding a match in those values. Then try

Sum({< Dos_StatusID = {1002,1050} >} Sales)

Separating values by comma in the possible list of values will work.

Regards.

Tue, 16 Feb 2010 11:14:46 GMT

Yes,

But the problem is that i have an if() around this all.

so the function is if(match(Statusid,1001,1051)<>0),...,....)

the problem is that is use <>0 so i can't use in my set -= or = to compare

...

Anonymous — Tue, 16 Feb 2010 11:22:01 GMT

match returns 0 if statusid is not equal to 1001 or 1051

with the if you check if this result is matched or not ...

Think the suggestion of Miguel is correct ... since the Set Analysis says the value should be matching the values {1001, 1050 } .


Miguel A. Baeyens wrote:<pre>Sum({< Dos_StatusID = {1002,1050} >} Sales)

Anita