topic A table with multiple rows per record in QlikView

A table with multiple rows per record

Wed, 21 Dec 2011 00:55:38 GMT

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

A table with multiple rows per record

pover — Wed, 21 Dec 2011 01:08:52 GMT

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

A table with multiple rows per record

Wed, 21 Dec 2011 23:28:56 GMT

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.

A table with multiple rows per record

pover — Wed, 21 Dec 2011 23:36:01 GMT

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