1 Reply Latest reply: Mar 14, 2017 4:23 AM by Vineeth Pujari RSS

    Function for capture date 1 week before.

    Ilham Raspati

      Hi,

       

      I have dashboard weekly reporting, and the simple table is below:

      DateService Quality
      01/01/1712
      02/01/1713
      03/01/1733
      04/01/1743
      05/01/1772
      06/01/1711
      07/01/1747
      08/01/1767
      09/01/1721
      10/01/1752

      Today : 11/01/17 (for example)

       

      - I want to create a bar chart, but only for 1 week before (04/01/17 - 10/01/17).

       

      I already tried function on this link: https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/DateAndTimeFunctions.htm, but no function meet with my question.

       

      Thank You.