5 Replies Latest reply: Mar 9, 2017 6:42 AM by Samane Ramezani RSS

    "OR" operator in set analysis

      Hi everybody,

       

      I'm new to QV,

       

      In a set analysis, I would like to sum according to conditions that are stocked in two different columns. Let's say column A and B have to be positive

       

      • sum(DISTINCT {<column_A={'>0'}, column_B={'>0'}>} quantity) gives me the quantity if both conditions ar realized

       

      • the * operator seems to work only for conditions within the same column, for instance : column_A={'b' * 'a'}

       

      • sum(DISTINCT {<column_A={'>0'} or column_B={'>0'}>} quantity) seems not to work at all

       

      I have the feeling that this is a very simple problem but looking for "set analysis or" in the forum doesn't help a lot as 'or' is not a very distinctive word...

       

      Someone can give me a hint ?