10 Replies Latest reply: Sep 26, 2018 12:02 PM by Andrea Gigliotti RSS

    How to filter data on the previous week?

    thierno DIALLO

      Hi everyone !


      I solicit your help because it's been over a week that I use Qlik and I have a lot of trouble with the syntax of set analysis. I can not filter my data (which runs from August 2017 to today) weekly.

      My goal is to show the sum of the numbers only from last week. Here is the last iteration of my work:

       

      Sum ({$ <semaine = {"= $ (= week (weekstart (today (), -1, first_week_day = 0)))"}>} etat_ok)

       

      "semaine" is a column containing the number of the week (0 -> 53)

      Can you tell me what's wrong? Or maybe point me to a document explaining how set analysis works ? or both ?