Dates Issue

Wed, 01 Apr 2015 18:05:51 GMT

Hi All,

I have one column 'Phase' which contains phases like Design, Dev, SIT, UAT, PROD and I have one more column 'Finish Date' which contains finish dates of projects.

I have one more column 'Project Start Date'. Here Project Start Date is Design Start Date and Design End Date is Finish Date.

Design Finish Date + 1 is 'Development Start Date' and Development Finish Date we have 'Finish Date'.

Development Finish Date +1 is 'SIT Start Date' , SIT Finish Date +1 is 'UAT Start Date', UAT Finish Date +1 is 'PROD Start Date'.

Like that i need to get the data, Could you please help me on this?

I attached req on QVW also

I tried with if(Phase='Design',date(Finish Date,'MM/DD/YYYY')) as Design Finish Date like this i did for all Phases but it's not working in Straight/ Pivot table:

Could you please help me here.

Thanks,

Chiru

Re: Dates Issue

ziadm — Wed, 01 Apr 2015 18:34:55 GMT

You have to sequence your project phases in the right order. use applymap to provide you with the right project sequnce

ProjectSeq:

Mapping

LOAD * INLINE [

Project ID, Sequance

A1-A2-A3, 1

A4-A5-A6, 2

A7-A8-A9, 3

A10-A11-A12, 4

B1-B2-B3, 5

B4-B5-B6, 6

B7-B8-B9, 7

];

ListProjects:

LOAD [Project ID],

ApplyMap([Project ID],99) as [Project Sequence],

Phase,

[Finish Date]

FROM

(ooxml, embedded labels, table is Sheet1);

Project:

LOAD [Project ID],

ApplyMap([Project ID],99) as [Project Sequence],

Phase,

[Finish Date],

[Finish Date] - Ndays as [Start Date]

Resident ListProjects Order by [Project Sequence];

drop Table ListProjects;

hope this will give you an idea ..

topic Dates Issue in QlikView

Dates Issue

Re: Dates Issue