Working with loaded data

AbhijitBansode — Thu, 03 Feb 2011 12:05:20 GMT

Hi ,

I'm generating a table below by doing some calculations in QlikView:

Key	As of term	Term	Type
101	2009 1st term	2009 1st term	Current
102	2009 2nd term	2009 2nd term	Current
103	2010 1st term	2010 1st term	Current
104	2010 2nd term	2010 2nd term	Current
	2009 1st term	2008 2nd term	Previous
	2009 2nd term	2009 1st term	Previous
	2010 1st term	2009 2nd term	Previous
	2010 2nd term	2010 1st term	Previous

Now my requirement is to update keys of this table when Type=Previous, depending upon the values of other column.

e.g.

1]When type=Previous, AsOfterm=2009 1st Term, Term=2008 2nd term

on this row, QlikView Query executer should serach for the values of Term (here 2008 2nd term), find the matching value in the AsOfTerm column and when the mathch is found , that record's key value should be copied to the current row. here key is updated as -, because 2008 2nd term value is not present in AsOfTerm column.

2] When type=Previous, AsOfterm=2009 2nd Term, Term=2009 1st term

here key is updated as 101

Below is ths expected O/P table:

Key	As of term	Term	Type
101	2009 1st term	2009 1st term	Current
102	2009 2nd term	2009 2nd term	Current
103	2010 1st term	2010 1st term	Current
104	2010 2nd term	2010 2nd term	Current
-	2009 1st term	2008 2nd term	Previous
101	2009 2nd term	2009 1st term	Previous
102	2010 1st term	2009 2nd term	Previous
103	2010 2nd term	2010 1st term	Previous

can anybody guide me, how to achive above requirement?

topic Working with loaded data in QlikView

Working with loaded data