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

      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?