4 Replies Latest reply: Jun 24, 2016 7:58 AM by Sunny Talwar RSS

    Adding filter to cumulative total

    ARINDAM DUTTA

      Hi Everyone

      I am new to qlik sense .I am using the following function to get the cumulitive registered customer on each day for the last 7 day.But now I have to add a country filter to it .So that I can visualise the total registered customer for those countries only can any one suggest where to make change in this expression to add this criteria.

       

      Sum({$<Date={'<=$(=(Max(Date))) >=$(=Date(Max(Date)-7))'}, ClientStatus = {0} >} Aggr(RangeSum(Above(Count({1} Distinct Reg_ClientNumber),0,RowNo())),DataWeekNo))