make date year quater not working

kunkumnaveen — Thu, 03 Mar 2016 06:14:14 GMT

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

Re: make date year quater not working

t_chetirbok — Thu, 03 Mar 2016 06:21:31 GMT

Hello!

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

Date format doesn't include quarter

topic make date year quater not working in QlikView

make date year quater not working

Re: make date year quater not working