Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I believe it would just be: if(A=B and E=F,C,else statment)
I believe it would just be: if(A=B and E=F,C,else statment)
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?
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.