0 Replies Latest reply: Apr 17, 2013 7:45 AM by John Pals RSS

    How to use dynamic reporting periods in a trigger

      Hi Qlikview experts,

       

      I want to show dynamic periods (Years)  in a Dashboard.

       

      What I did till now.

      - Made a variabele - Years_back. e.g input =2,Result = 2011 (in combination with Year (today()) function.

      - Made a variabele - Years_forward. e.g. input = 3,  Result = 2016

       

      In Settings

      Sheet properties
      Triggers.

      On activate sheet add Action

      Select in Field

      - selected Field = Year

      - search String used the function Valueloop

       

      (= ValueLoop($(Years_back), ($ Years_forward) .

       

      This does not work. Where did I go wrong?