topic Re: Creating Date in QlikView

Creating Date

Anonymous — Thu, 22 Nov 2012 11:10:44 GMT

Hi All,

DISTCODE	CRNT_STCK PRODCODE	CalDate
600984	11340015	31/07/2012
600984	11340015	31/08/2012
600984	11340025	31/07/2012
600984	11340025	31/08/2012

for every distcode and its product , I want to create a Caldate till today.

Eg:

Discode Prod CadDate

600984 11340015 31/7/2012

600984 11340015 31/8/2012

600984 11340015 30/9/2012

600984 11340015 31/10/2012

Same for the Other Prod code.

Likewise , I ahve many Distcode and Multiple products.

Please Help

Re: Creating Date

jagannalla — Thu, 22 Nov 2012 11:16:54 GMT

Hello,

You are trying to say that for each distcode and product you need caldate.

what is the start date for each distcode and product?

If possible please share your sample source data what you have.

Cheers!!

Jagan

Re: Creating Date

Anonymous — Thu, 22 Nov 2012 11:30:43 GMT

DISTCODE	CRNT_STCK PRODCODE	CalDate
600984	11340015	31/07/2012
600984	11340015	31/08/2012
600984	11340025	31/07/2012
600984	11340025	31/08/2012
600984	11340156	31/07/2012
600984	11340156	31/08/2012
600984	11340157	31/07/2012
600984	11340157	31/08/2012
600984	11340214	31/07/2012
600984	11340214	31/08/2012
600984	11450190	31/07/2012
600984	11450190	31/08/2012
600984	12015250	31/07/2012
600984	12015250	31/08/2012
600984	12049301	31/07/2012
600984	12049301	31/08/2012
600984	12051784	31/07/2012
600984	12051784	31/08/2012
600984	12081203	31/07/2012
600984	12081203	31/08/2012
600984	12146624	31/07/2012
600984	12146624	31/08/2012
600984	12150438	31/07/2012
600984	12150438	31/08/2012
600984	12152461	31/07/2012
600984	12152461	31/08/2012
600984	12160802	31/07/2012
600984	12160802	31/08/2012
600984	12161728	31/07/2012
600984	12161728	31/08/2012
600984	12167438	31/07/2012
600984	12167438	31/08/2012
600984	12178140	31/07/2012
600984	12178140	31/08/2012

there are many Distcode with Such Cases.

Re: Creating Date

jagannalla — Thu, 22 Nov 2012 11:38:14 GMT

I'm getting little bit confuse. Do you have 3 or 2 columns in your source file?

I thought that you have only 2 columns i.e. distcode and product. Ok whatever it is if you have 3 columns then what you need output according to your source file data you mention in the above post.

What is the input you have now?

What is the expected output you need?

Cheers!!

Jagan

Re: Creating Date

Anonymous — Thu, 22 Nov 2012 11:41:51 GMT

Input is :

600984	11340015	31/07/2012
600984	11340015	31/08/2012

Output should be

Discode Prod CadDate

600984 11340015 31/7/2012

600984 11340015 31/8/2012

600984 11340015 30/9/2012

600984 11340015 31/10/2012

for DistCode 600984 and Prodcode 11340015