1 Reply Latest reply: Mar 3, 2016 1:22 AM by Tatsiana Chetirbok RSS

    make date year quater not working

    naveen kumar

      Hello,i am not getting any error while reload at the same time i am not getting the required output data.........

      i am getting year field,quaters fields  from DATE_OF_REVIEW and later i am trying to join them both by using two functiond

                                                     1.makedate= MakeDate(YEAR,QUATERS) AS YEARQUATER

                                                      2.date#= date(Date#(YEAR&''&QUATERS),'YYYYQ') AS YEARQUATER

      looks like  either function is not working ....can u say why .....



      o/p i am looking is:  YEARQUATERS

                                           2015Q1

                                            2015Q2

                                              2015Q3

                                               2015Q4.......

      SO ON





      SuppilerScore:

      LOAD CLIENT,

           LIFNR,

           VENDOR_NAME,

           ROLE,

           DATE_OF_REVIEW,

           QM_SCORE,

           QM_MAX,

           CS_SCORE,

           CS_MAX,

           GENERAL_SCORE,

           GENERAL_MAX,

           PROC_SCORE,

           PROC_MAX,

           MANU_SCORE,

           MANU_MAX,

           TOTAL_SCORE,

           MAX_SCORE,

            'Q'&Ceil(MONTH(DATE_OF_REVIEW)/3) AS QUATERS,

          //year(DATE_OF_REVIEW) as YEAR,

          Year(Date(DATE_OF_REVIEW, 'YYYY-MM-DD'))AS YEAR

         FROM

      [C:\qlikview\QVDS\SuppilerScore.qvd]

      (qvd);

      TABLE2:

      LOAD

      VENDOR_NAME as name1,

           ROLE,

           DATE_OF_REVIEW,

            QM_SCORE,

       

           CS_SCORE,

       

           GENERAL_SCORE,

         

           PROC_SCORE,

        

           MANU_SCORE,

             TOTAL_SCORE,

          

           QUATERS,

           YEAR,

         date(Date#(YEAR&''&QUATERS),'YYYYQ') AS YEARQUATER

          //MakeDate(YEAR,QUATERS) AS YEARQUATER

         Resident SuppilerScore;

          DROP Table SuppilerScore;

      thanks

      naveen