topic Re: Explode Summary table to detail table in QlikView

Explode Summary table to detail table

bismart — Wed, 30 Oct 2013 13:51:43 GMT

I have a summary table as follows;

I want to explode the table to a new table with number of rows for each Product Category as defined in the Rows column.

Required:

Category A has 3 rows.. Category B as 4 etc.

In the new detailed table I also want to create a new field (Code) which can be any sequential number series.

Anybody any ideas how to achieve this?

Thanks

swuehl — Wed, 30 Oct 2013 13:56:44 GMT

Maybe like this:

LOAD *, iterno() as Code INLINE [

Product Category, ASP, Units, Rows

Category A, 120.00, 1389, 3

Category B, 26.67, 703, 4

Category C, 191.25, 784, 2

] while iterno() <= Rows;

bismart — Wed, 30 Oct 2013 14:09:39 GMT

Thanks for that

Works a treat