4 Replies Latest reply: Apr 27, 2015 4:07 PM by Sunny Talwar RSS

    Calculating Sum while excluding and including conditions

      I'm attempting to sum a value while conditionally excluding and including specific rows based on specific conditions.  I generated the following expression using the set analysis wizard for QlikView:


      =Sum({$<Exchange-={'$(=OTC)','$(=NULL)','$(=PNK)'},[TR Adjusted Derivative Type]={'$(=Non-Derivative)'},[Trade to be Excluded?]={'$(=N)'}>}[TR Notional Value])


      There are no values returned.  Something may be wrong with the syntax, but am unable to determine the problem.  Any feedback would be helpful.