Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
timmy
Partner - Contributor III
Partner - Contributor III

Transform match into set analysis



Hey

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

Match

tnx

Timmy

(Dos_StatusId,1002,1050)<>0



4 Replies
Miguel_Angel_Baeyens

Sorry for the double post.

Miguel_Angel_Baeyens

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.

Not applicable

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
Not applicable

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