How to split a table by a field value

Tue, 12 Jun 2012 16:06:30 GMT

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 | 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.

Re: How to split a table by a field value

Tue, 12 Jun 2012 16:28:43 GMT

Does this work?

Preview the data in Table viewer.
Regards,

Kiran Rokkam.