0 Replies Latest reply: Aug 7, 2017 7:05 AM by antony qvw RSS

    Cal_doubt

    antony qvw

      Hi Experts,

       

       

      I have created Fiscal calendar based on the DOJ(date of joining) and DOL(date of leaving)

      Generated the dates(CalDate) From DOJ to DOL for each emplyoyee.

      If emplyoyee has no DOL , then generated the dates(CalDate) till today from DOJ

       

       

      Till now It's working fine.No worries.

       

       

      But Performence prespective I want to reduce the data

      So,

      I don't want to load all the dates from DOJ to DOL or till date

      Instead of this, load only MonthEND date

       

       

      For example,

      Emp1  has only DOJ(25-Dec-2016)

      Now generate the dates from DOJ to till date(i.e 25-Dec-2016 to Tilldate(07-Aug-2017))

       

       

      As we created calendar we can the dates from 25-Dec-2016 to Tilldate

       

       

      But here my requirement is

       

       

      Only Load instead of loading all the dates

       

      25-Dec-2016,

      26-dec-2016,

      27-Dec-2016.......31-Dec-2016

       

      and

       

      Instead of load all the dates for Jan-2017 load only Monthend date (31-Jan-2017)

      Instead of load all the dates for Feb-2017 load only Monthend date (28-Feb-2017)

      .........................

      For July-2017 Load only 31-Jul-2017

       

      and

       

       

      1-Aug-2017

      2-Aug-2017

      3-Aug-2017........till 07-Aug-2017

       

       

      How to accomplish this?

       

       

      am sharing my dummy Excel file(which I have exported from qlikview)

       

      Can some one help me out in this??

       

       

       

      Awaiting for your response!!!