A table with multiple rows per record

[#1]

Does anybody know if it's possible to create a table similar to this, with the field arranged in multiple rows per record? Thanks.

[pover]

If you add a dimension that keeps track of the row number, you might be able to achieve something similiar to what you're looking for by creating 3 expressions that would have an expression similiar to the following:

pick(only(RowNoDim),'Field1',sum(Value1),'Field4',sum(Value4))

I don't recommend doing this because of performance and because it makes QlikView more complicated than what it should be.  What you can easily do in a pivot table is drag and drop the group of expressions so that they are aligned vertically instead of horizontally if you have a lack of horizontal space to show all the values.

Regards, Karl

[#3]

Thanks for the help, that pivot table technique is really helpful and is almost what I want. Do you know if I could get it to do multiple columns of fields like this?

Also I think I see what you're getting at with that expression and that's pretty slick. If I can't get the pivot table to do what I want I might go that route. Thanks.

[pover]

If you don't have to scroll you could create 2 different tables and make them look like one table, but I'm assuming you'll have to scroll through the table so you might have to try the method I mentioned above if this format is a must.

Regards, Karl