How to split a table by a field value

[#1]

Hi

I have a some data in Excel which

The table follows the following structure:

Date          | Code | Value

01/01/2011 |1402  | 10

01/01/2012 |1405  | 5

I want to be able to split this data so that there is one row for each code which totals to the value in the above table.

An example is:

Date          | Code | Value

01/01/2011 | 1402 | 1

01/01/2011 | 1402 | 1

01/01/2011 | 1402 | 1

01/01/2011 | 1402 | 1

01/01/2011 | 1402 | 1

01/01/2011 | 1402 | 1

01/01/2011 | 1402 | 1

01/01/2011 | 1402 | 1

01/01/2011 | 1402 | 1

01/01/2011 | 1402 | 1

01/01/2011 | 1405 | 1

01/01/2011 | 1405 | 1

01/01/2011 | 1405 | 1

01/01/2011 | 1405 | 1

01/01/2011 | 1405 | 1

Does anyone know how to achieve the above result in QlikView. This is achievable in Excel but I need to be able to do this in QlikView.

[#2]

Does this work?

Preview the data in Table viewer.
Regards,

Kiran Rokkam.