7 Replies Latest reply: Aug 1, 2017 7:36 AM by Leonardo Hernandez Mengesha RSS

    Variable call in Set Analysis not working

    Leonardo Hernandez Mengesha

      I have the following Set expression within one of the dimensions of a straight table:

       

      Sum({$<$(vSetPreviousNMonth(0))>} [# Departures Performed])

       

      where vSetPreviousNMonth has the following definition:


      PeriodID = {$(=Max(PeriodID) – $1)}, Year = , Quarter = , Month = , Period =


      leaving $1 to insert parameters and output something else, the problem is that this does not work and the script syntax highlighting

      displays it as an error. Is this expression written properly or is there a specific reason this does not work?

       

      PS: I'm relatively new to Set analysis and Qlikview overall