26 Replies Latest reply: Aug 25, 2015 10:36 AM by Kaushik Solanki RSS

    Not able to restrict 31 days data

      Hello experts,

      I am  new to Qlik view and

      I am trying to restrict data for last 31 days data from max date. Actually date field is time stamp and converted that into date by floor function and used it in expression like below.

       

      =Count({<[DateOnly]={">=$(=Date(Max([DateOnly])-30))<=$(=Date(Max([DateOnly])))"} >} DISTINCT [Visitor ID])

       

      But it is giving complete data and not able to restrict 31 days data.

       

      Regards,

      Nanda