topic Re: How I create a pipeline? in QlikView

How I create a pipeline?

seband_fredes — Wed, 19 Aug 2020 19:54:03 GMT

Hi everyone, I need your helpyou in this case. I need to create a pipeline with the contract services that actually I've. I've a dataset with this:

ID_Contract	CstmrCode	CstmrName	Cluster	CreateDate	EndDate	$$$
20089	1	A	1	01-09-2017	31-08-2020	$352.000
21122	2	B	2	01-09-2017	01-09-2020	$166.666
23537	3	C	4	19-04-2018	31-03-2021	$352.000

In the first row, I've a contract service, it's started in 1/9/2017 (dd/mm/yyyy) and finish at 31-08-2020. All the contracts are monthly invoiced.

I need create a table with this characteristics:

ID	CstmrCode	CstmrName	Cluster	CreateDate	EndDate	FlowDate	$$$
20089	1	A	1	01-09-2017	31-08-2020	01-09-2017	$352.000
20089	1	A	1	01-09-2017	31-08-2020	01-10-2017	$352.000
20089	1	A	1	01-09-2017	31-08-2020	01-11-2017	$352.000
…	…	…	…	…	…	…	…
20089	1	A	1	01-09-2017	31-08-2020	01-07-2020	$352.000
20089	1	A	1	01-09-2017	31-08-2020	01-08-2020	$352.000

Thanks for all.

Blessings.

Re: How I create a pipeline?

Kushal_Chawda — Wed, 19 Aug 2020 21:10:26 GMT

try below

Data: LOAD ID_Contract, CstmrCode, CstmrName, Cluster, CreateDate, monthstart(CreateDate,IterNo()-1) as Flow_Date, EndDate, $$$ FROM Table while monthstart(CreateDate,IterNo()-1)<= EndDate;

Re: How I create a pipeline?

seband_fredes — Mon, 24 Aug 2020 17:04:53 GMT

Thaks so much, it was very usefull your solution. How would it be done so that the flow-date is quarterly or semi-annual?

Quarterly example:

-This is the exam contract=

D_Contract	CstmrCode	CstmrName	Cluster	CreateDate	EndDate	$$$
20089	1	A	1	01-08-2020	31-07-2021	$352.000

-This is my goal's example=

ID	CstmrCode	CstmrName	Cluster	CreateDate	EndDate	FlowDate	$$$
20089	1	A	1	01-08-2020	31-07-2021	01-08-2020	$352.000
20089	1	A	1	01-08-2020	31-07-2021	01-12-2020	$352.000
20089	1	A	1	01-08-2020	31-07-2021	01-04-2021	$352.000