topic Re: Periods in QlikView

Periods

Anonymous — Mon, 23 Sep 2013 12:28:11 GMT

Hi all,

I have this:

and I want this:

Regards,

Arjan

Mon, 23 Sep 2013 13:19:20 GMT

It might work if you make some changes to your script.

Instead of loading to table as it is try loading:

[MyTable]

LOAD

Key,

Min(Dates) as Date1,

Max(Dates) as Date2

FROM

Hope it helps

MayilVahanan — Mon, 23 Sep 2013 13:32:57 GMT

May be like this

Load

KEY,

If(Count(Dates) > 1, Date(Max(Dates))) as Dates2,

Date(Min(Dates)) as Dates1 Resident

Test

Group by KEY;

DROP Table Test;