8 Replies Latest reply: Oct 11, 2017 3:19 PM by Sergey Belov RSS

    The problem with Set analysis, how to change current selection

    Sergey Belov

      I have a table with date month and earn sum. I try to get the last year sum  earn happended relatively  current month selection like this:

      sum({$<Month={"$(=AddMonths(Only(Month),-12))"}>} earn)

      but get only zero. This code on QlikView on the same data works properly. Please help. i'm stuck with this problem ((