17 Replies Latest reply: Jul 28, 2017 10:42 AM by Gabor Kubler RSS

    Correcting an expression error in set analysis

    John Worth

      I'm working on data set from a book titled "QlikView Your Business" I have an error in the expression that I'm unable to fix and I'm looking for a little help.

       

      sum ({$<$(filter_ThisYear)>}error message starts here. [# Amount] )/

      sum ({$<$(filter_PriorYear)>} [# Amount] ) -1

       

      This set analysis is working off of 2 variables

      filter_ThisYear = Year={$(=max(Year))}

      filter_PriorYear = Year=[$(=max(Year)-1}

       

      troyansky