2 Replies Latest reply: Dec 13, 2016 7:56 AM by John Blomqvist RSS

    How to write Set Analysis to select the previous two weeks (Monday to Sunday) from  the current date?

    John Blomqvist

      Hi all,

       

      How to write Set Analysis to select the previous two weeks (Monday to Sunday) from the current date?

       

      For example today is 13th December, I need Set Analysis to select the previous two weeks for me automatically

       

       

      E.g. November 28th (Monday) to 11th (Sunday) December on the above.

       

      If I were to visit my QlikView application tomorrow (14th) it should still select the same date range.

       

      But if I was to access the app next week, it should now select December 5th (Monday) to 18th (Sunday) December.

       

      Anyone know how to get set analysis to automatically select this type of date range please?

       

      You can use Date as a field name example for your example code.