"Where" statement in expression

[#1]

Is there any way to write "where" statement in charts. For example, for a 5 column (a,b,c,d,e) martix how would you write IF (A=B), ReturnC where E=F, i.e. if A is equal to B, then return C only where D is equal to E. Every help is really appreciated. Thanks!

[#2 · Accepted solution]

I believe it would just be:  if(A=B and E=F,C,else statment)

[#3]

Thanks Nicole,

For this part it worked fine, but if sometime you have to write a 'where" logic? Do you know if QV has something similar to 'where' statement of c/c++/SQL?

[#4]

I believe you can use a where statement in the load script that is similar to SQL.  I am on the user end, so I don't have much experience with the load script.  I did a search in QV help though and found a little info on it.  On the expression side, I think set analysis may handle some where logic, but that of course depends on exactly what you are trying to acheive.