topic Doubt in Previous () in QlikView

Doubt in Previous ()

Thu, 24 Dec 2015 07:18:33 GMT

I do this type for Previous () ( it returns the values of expression using data from the previous input record

Data:

LOAD * INLINE [

Emp_No, Emp_Name, Join_Date

1, Mani, 15-01-2013

2, deep, 16-02-2013

3, Sudeep, 17-08-2012

4, mani, 19-06-2011

5, Jaya, 16-12-2010

] ;

LOAD Previous(Previous(Emp_Name) )as Name Resident Data ;

but my data is come this type

Emp_No	Emp_Name	Join_Date	Name
2	deep	16-02-2013	Mani
2	deep	16-02-2013	deep
2	deep	16-02-2013	Sudeep
5	Jaya	16-12-2010	Mani
5	Jaya	16-12-2010	deep
5	Jaya	16-12-2010	Sudeep
1	Mani	15-01-2013	Mani
1	Mani	15-01-2013	deep
1	Mani	15-01-2013	Sudeep
4	mani	19-06-2011	Mani
4	mani	19-06-2011	deep
4	mani	19-06-2011	Sudeep
3	Sudeep	17-08-2012	Mani
3	Sudeep	17-08-2012	deep
3	Sudeep	17-08-2012	Sudeep

my doubt is why the data is coming more times how it is evaluated?

Re: Doubt in Previous ()

settu_periasamy — Thu, 24 Dec 2015 07:31:45 GMT

Is this your actual script? There is extra paranthesis in the previous table.. not a problem.

But , I think your script will act as a full outer join.

How do you want the result?

Re: Doubt in Previous ()

MK_QSL — Thu, 24 Dec 2015 07:42:00 GMT

Data:
LOAD * INLINE 
[
    Emp_No, Emp_Name, Join_Date
    1, Mani, 15-01-2013
    2, deep, 16-02-2013
    3, Sudeep, 17-08-2012
    4, mani, 19-06-2011
    5, Jaya, 16-12-2010
];


Left Join (Data)
Load Emp_No, Previous(Emp_Name) as Name Resident Data
Order By Join_Date;

Re: Doubt in Previous ()

Peter_Cammaert — Thu, 24 Dec 2015 07:53:32 GMT

Not the script but the sheet object you create from two tables without any association will create an outer join (aka Cartesian Product). See Manish's example to correct this situation.