Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

make date year quater not working

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

(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

1 Solution

Accepted Solutions
t_chetirbok
Valued Contributor

Re: make date year quater not working

Hello!

What if you'll make field like this: YEAR&QUATERS AS YEARQUATER

Date format doesn't include quarter

1 Reply
t_chetirbok
Valued Contributor

Re: make date year quater not working

Hello!

What if you'll make field like this: YEAR&QUATERS AS YEARQUATER

Date format doesn't include quarter

Community Browser