2 Replies Latest reply: Dec 13, 2017 4:15 PM by Chris Allen RSS

    Qlik Sense Count Distinct rows in last week

    Chris Allen

      Hi all,

       

      I am trying to make a graph to count the number of distinct changelogs + detailID occurring in the last week.

       

      I have these two formula's in various other parts of the app and thought I could combine the count distinct with the look for the last week, but am not having any luck.

       

      =count(distinct ChangeLog&'-'&DetailID)


      =Count({<InputType = {'Error'}, Date = {">=$(=Date(Today()-7, 'YYYY-MM-DD'))"}>} InputType)

       


      DateVersionSiteChangeLogDetailID
      2017-12-092.5AAAabcd1
      2017-12-092.3SSSabcd2
      2017-12-072.3BBBabcd1
      2017-11-312.1AAAefghi3

       


      Any help would be much appreciated.

       

      Thanks