topic Open lines in Profit & Loss Statement in QlikView

Open lines in Profit & Loss Statement

Thu, 29 Jul 2010 07:04:03 GMT

Good day everyone

I mapped/grouped all my accounts to certain groups for example I grouped all my Sales Accounts to TURNOVER etc etc.

The thing that I would like to know is, how do I create a blank line between GP & OVERHEADS for example.

At the moment all may lines follow each other directly.

Thank you in advance.

Open lines in Profit & Loss Statement

Thu, 29 Jul 2010 07:49:24 GMT

Im sorry i dont quite understand what you mean? is it in a table, a graph....? can u post a screen shot maybe?

Open lines in Profit & Loss Statement

Thu, 29 Jul 2010 08:13:55 GMT

This is in a chart in Qlikview. This is how it looks at the moment. How do I create a space between the GP & PERSONNEL COSTS for example.

Open lines in Profit & Loss Statement

jonathandienst — Thu, 29 Jul 2010 08:21:40 GMT

Christo

It is possible to do something along those lines by playing around with the layout. Split the chart into two or more sections, selectively turn off captions/borders and possibly underlay the combined charts with a frame (eg transparent text box with border). This can become quite complex to lay out and maintain, so you must decide if it is worth the effort.

Jonathan

Open lines in Profit & Loss Statement

jonathandienst — Thu, 29 Jul 2010 08:23:36 GMT

By sections, I mean splitting the chart into two or more charts with the same dimensions, with the existing expessions in the appropriate split chart.

Jonathan