P&L template

[#1]

Hi,

I just want to ask if this is possible in qlikview and how is this done?

please take note of the indention (hierarchy purposes)

[#2]

Thanks in advance!!

[tanelry]

Yes, it is possible.

The most simple option is to use pivot table with Style: Indent Mode (see attached).

If it doesn't meet the requirements, you may need some more complex datamodeling/scripting (to handle many-to-many links between account and reportrow).

[#4]

thank you sir.. any other suggestions??

[#5]

up..

[#6]

up

[#7]

up

[#8]

hi,

This can be achieved usinf=g hirerchy function:

Here is the example..:

[#9]

I think you should try to use hirerchy function.