5 Replies Latest reply: Aug 2, 2016 11:39 AM by Francisca Tirado RSS

    Count the last day of the week registered

    Francisca Tirado

      Hello,

       

      I am new on Qlik Sense and  If anyone can help me with the following situation:

       

      I have the following table:

       

      WeekDateAmount
      2016/3101-08-20161219
      2016/3031-07-20161205
      2016/3030-07-2016905
      2016/3029-07-2016755
      2016/3028-07-2016640
      2016/3027-07-20161355
      2016/3026-07-20161548
      2016/3025-07-20161520
      2016/2924-07-20161520
      2016/2923-07-20161357
      2016/2922-07-20161049
      2016/2921-07-20161005
      2016/2920-07-2016697
      2016/2919-07-2016654
      2016/2918-07-2016249
      2016/2815-07-2016246

       

      Where the amount field is a Count (distict  ID_pallet). I need to count the quantities for weeks for the last day on record of each week. I mean:

       

      WeekDateAmount
      2016/3101-08-20161219
      2016/3031-07-20161205
      2016/2924-07-20161520
      2016/2815-07-2016246

       

      I can't do it directly on the script because i also need the day for other analysis.

       

      Beforehand thank you very much.