4 Replies Latest reply: Jan 4, 2017 9:29 PM by Sunny Talwar RSS

    Previous Monthstart till date values for selected date in Script

    Yuvraj Killedar

      Dear All,

       

      I am having a scenario where I am having a table with fields as below:

       

      Table:

      Material,

      Date,

      Value

       

      I need to fetch data from previous month start date till selected date.

      i.e. If date 25-12-2016 is selected, then all materials from 01-11-2016 to 25-12-2016 need to appear for the selection.

       

      I need to achieve this in Qlikview script and not in front end.

       

      Kindly assist on mentioned query.

       

      Thanks in advance.