topic Creating Data in QlikView

Creating Data

Fri, 28 Aug 2015 15:36:09 GMT

Hey All,

I am trying to produce a table, where one of the columns are fabricated, and I am not sure if it is possible.

In my example I have Slot and Reactor - both of which are related in the data (though they come from different QVDs) and can be put in the table. In the example the red field is what I am trying to add - it is always five weeks later than when Reactor sits:

*Slot*	Reactor	*Purification*
01/05/15
01/12/15	Product 1
01/19/15
01/26/15	Product 2
02/02/15
02/09/15	Product 3
02/16/15		Product 1
02/23/15
03/02/15	Product 4	Product 2
03/09/15	Product 5
03/16/15	Product 6	Product 3
03/23/15
03/30/15
04/06/15		Product 4
04/13/15		Product 5
04/20/15	Product 6

I hope this makes sense to someone else, and is do-able.

Thanks,

Vince

Re: Creating Data

maxgro — Fri, 28 Aug 2015 15:46:01 GMT

try this

SET DateFormat='MM/DD/YYYY';

LOAD Slot,

Reactor,

Purification

FROM

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

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

left join (a)

load

date(Slot+35) as Slot,

Reactor as PurificationCalc

Resident a;

Re: Creating Data

Fri, 28 Aug 2015 17:01:33 GMT

The problem is that slot and and reactor are from different tables so I do not know how to load them together.

Re: Creating Data

maxgro — Fri, 28 Aug 2015 17:33:08 GMT

You need one or more common fields to join the two tables when you load the 2 qvd files.

Then, when you have one table, apply my script.

If you can, post the 2 qvd and explain how they are related.

Re: Creating Data

Fri, 28 Aug 2015 18:00:01 GMT

They link to one another through a third table and separate fields

Re: Creating Data

MarcoWedel — Fri, 28 Aug 2015 22:50:50 GMT

please provide sample data to clarify.

regards

Marco

Re: Creating Data

crusader_ — Mon, 31 Aug 2015 13:15:01 GMT

Hi Vincent,

It's not a problem in fact.

If you matched these fields in your mind or in Excel spreasheet QlikView is able to do it as well.

Please provide more information or ER-diagram. It helps us to suggest a solutions for you.

Regards,

Andrei