Filter and transpose data

Fri, 25 Jul 2014 12:00:19 GMT

Hi,

I have two tables. One with Date and associated values of sales. There is another table which has 2 columns : CYDate,PYDate . I need to create new table with columns : CYDate, PYDate,CYValue,PYValue. I am finding it difficult to do the same qlikview. I need to do this at script level only for certain calculations. Can someone guide ?

Souce table 1 :

Date	Sales
1/1/2014	123
1/2/2014	124
1/3/2014	125
1/4/2014	123
1/5/2014	124
1/6/2014	124
1/7/2014	124
1/8/2014	124
1/9/2014	124
1/10/2014	125
1/2/2013	125
1/3/2013	125
1/4/2013	125
1/5/2013	125
1/6/2013	125
1/7/2013	125
1/8/2013	125
1/9/2013	125
1/10/2013	125
1/11/2013	126

Source Table 2:

CYDate	PYDATE
1/1/2014	1/2/2013
1/2/2014	1/3/2013
1/3/2014	1/4/2013
1/4/2014	1/5/2013
1/5/2014	1/6/2013
1/6/2014	1/7/2013
1/7/2014	1/8/2013
1/8/2014	1/9/2013
1/9/2014	1/10/2013
1/10/2014	1/11/2013

Required result :

CYDate	NPYDATE	CYSales	PYSales
1/1/2014	1/2/2013	123	125
1/2/2014	1/3/2013	124	125
1/3/2014	1/4/2013	125	125
1/4/2014	1/5/2013	123	125
1/5/2014	1/6/2013	124	125
1/6/2014	1/7/2013	124	125
1/7/2014	1/8/2013	124	125
1/8/2014	1/9/2013	124	125
1/9/2014	1/10/2013	124	125
1/10/2014	1/11/2013	125	126

Thanks,

Sailee

Re: Filter and transpose data

Gysbert_Wassenaar — Fri, 25 Jul 2014 12:05:28 GMT

MapSales:

MAPPING LOAD

Date,

Sales

FROM

SourceTable1;

Result:

LOAD

CYDate,

PYDATE as NPYDATE,

applymap('MapSales',CYDate,0) as CYSales,

applymap('MapSales',PYDate,0) as PYSales,

FROM

SourceTable2;

Re: Filter and transpose data

Thu, 31 Jul 2014 12:15:33 GMT

topic Re: Filter and transpose data in QlikView

Filter and transpose data

Re: Filter and transpose data

Re: Filter and transpose data

Thanks Gysbert.