topic Re: reshape table scripting in QlikView

reshape table scripting

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

Hi,

I load a Table.

Tasks:

LOAD [Object-ID],

Key,

start,

end

FROM

test.xlsx

(ooxml, embedded labels, table is table1);

This Table looks like this:

now I need a table with only one date and all the keys of the tasks that are open on that day.

The first day should be the first start day. The last day should be today.

The condition is:

date >= start and date < end

And I need a 3. column with the Information "open"

So my example should look like this:

Unfortunately, I have no idea how I can do this reshaping.

I hope someone can help me.

Alex

sunny_talwar — Tue, 30 Aug 2016 09:59:35 GMT

I think the sample output you have provided isn't correct, or may be I am missing something here. See if this is right

Table:

LOAD key,

Date(start + IterNo() - 1) as Date,

'Open' as Status

While start + IterNo() - 1 < end;

LOAD key,

start,

end

FROM

[https://community.qlik.com/thread/230851]

(html, codepage is 1252, embedded labels, table is @1);

qlikviewalex — Tue, 30 Aug 2016 11:32:41 GMT

Thanks.

It works well.