Discussion Board for collaboration related to QlikView App Development.
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.
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?
Go to Solution.
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;
View solution in original post
Thanks for that
Works a treat