8 Replies Latest reply: Dec 8, 2015 9:39 AM by Brijesh Maurya RSS

    How to get Start Date till End date in qliksense

    Brijesh Maurya

      Hi,

       

      I have one date field [Inventory Date] . I want to keep Start date always as 01/01/2011 and End date should be date with

      Customer select in list box for Inventory Date..

       

      set vStart =  min(Inventory Posting Date]) //// Minimum date for Posting Date is 01/01/2011.

      set vEnd =  Max(Inventory Posting Date])

       

      Sum({< [Inventory Posting Date] = {'>=$(=Date(vStart))<=$(=Date(vEnd))'} >} [Item Ledger Entry Quantity])..

       

      When User  Select Date from List box it should sum quantity from 01/01/2011 till selected Date.

       

       

       

       

       

      Kinldy Help me on this.. Thanks in Advanced.