2 Replies Latest reply: Mar 7, 2018 12:07 PM by Joanna Seldon RSS

    date dimension - qlik sense

    Joanna Seldon

      Hi

       

      using qlik sense

       

      I have the following as a dimension

       

      =

      IF(Date>=Date(Today()-70),Date)

       

      this shows latest 10 weeks activity on a chart / dashboard

       

      however... I wish to be able to pick a date from a filter (WeekCommencing), but if the week commencing date is before the latest 10 weeks of activity, it just shows me 10 weeks of activity from the week commencing date chosen

       

      please help