topic Re: Max date in comma separated date column in QlikView

Max date in comma separated date column

prat1507 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I've a column with comma separated date values. Approx 8000 records. I need to store the max date and min date in separate fields.

Kindly help.

Regards
Pratyush

Anil_Babu_Samineni — Thu, 14 Dec 2017 15:40:39 GMT

First you need to Bifurcate using SubField() ..

sunny_talwar — Thu, 14 Dec 2017 16:04:58 GMT

Something along these lines

Table:

LOAD Max(Dates) as MaxDate,

Min(Dates) as MinDate;

LOAD SubField(Dates, ',') as Dates;

LOAD * INLINE [

Dates

200,300,400,500

] (delimiter IS '|');

prat1507 — Thu, 14 Dec 2017 16:25:07 GMT

But how do I link this to my existing table?? Can I use resident load?

sunny_talwar — Thu, 14 Dec 2017 16:29:39 GMT

You sure can

prat1507 — Fri, 15 Dec 2017 08:04:37 GMT

Hi My data is as below:

I need min of Invoice Start Date and max of Invoice End date, along side Invoice in a separate table from this data. Could you plz help me with this.

prat1507 — Fri, 15 Dec 2017 08:21:46 GMT

Done on my own. Thanks a lot Sunny for the guidance.