topic P&L template in QlikView https://community.qlik.com/t5/QlikView/P-L-template/m-p/373626#M139054 <HTML><HEAD></HEAD><BODY><P>up</P></BODY></HTML> Thu, 29 Mar 2012 07:50:37 GMT 2012-03-29T07:50:37Z P&L template https://community.qlik.com/t5/QlikView/P-L-template/m-p/373620#M139048 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I just want to ask if this is possible in qlikview and how is this done?</P><P></P><P>please take note of the indention (hierarchy purposes)</P><P><IMG alt="forum.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12504_forum.JPG" width="450" /></P></BODY></HTML> Wed, 28 Mar 2012 10:35:19 GMT https://community.qlik.com/t5/QlikView/P-L-template/m-p/373620#M139048 2012-03-28T10:35:19Z P&L template https://community.qlik.com/t5/QlikView/P-L-template/m-p/373621#M139049 <HTML><HEAD></HEAD><BODY><P>Thanks in advance!!</P></BODY></HTML> Wed, 28 Mar 2012 10:46:53 GMT https://community.qlik.com/t5/QlikView/P-L-template/m-p/373621#M139049 2012-03-28T10:46:53Z Re: P&L template https://community.qlik.com/t5/QlikView/P-L-template/m-p/373622#M139050 <HTML><HEAD></HEAD><BODY><P>Yes, it is possible.</P><P>The most simple option is to use pivot table with Style: Indent Mode (see attached).</P><P>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).</P></BODY></HTML> Wed, 28 Mar 2012 14:41:44 GMT https://community.qlik.com/t5/QlikView/P-L-template/m-p/373622#M139050 tanelry 2012-03-28T14:41:44Z Re: P&L template https://community.qlik.com/t5/QlikView/P-L-template/m-p/373623#M139051 <HTML><HEAD></HEAD><BODY><P>thank you sir.. any other suggestions??</P></BODY></HTML> Wed, 28 Mar 2012 23:20:27 GMT https://community.qlik.com/t5/QlikView/P-L-template/m-p/373623#M139051 2012-03-28T23:20:27Z P&L template https://community.qlik.com/t5/QlikView/P-L-template/m-p/373624#M139052 <HTML><HEAD></HEAD><BODY><P>up..</P></BODY></HTML> Thu, 29 Mar 2012 01:51:36 GMT https://community.qlik.com/t5/QlikView/P-L-template/m-p/373624#M139052 2012-03-29T01:51:36Z P&L template https://community.qlik.com/t5/QlikView/P-L-template/m-p/373625#M139053 <HTML><HEAD></HEAD><BODY><P>up</P></BODY></HTML> Thu, 29 Mar 2012 05:10:47 GMT https://community.qlik.com/t5/QlikView/P-L-template/m-p/373625#M139053 2012-03-29T05:10:47Z P&L template https://community.qlik.com/t5/QlikView/P-L-template/m-p/373626#M139054 <HTML><HEAD></HEAD><BODY><P>up</P></BODY></HTML> Thu, 29 Mar 2012 07:50:37 GMT https://community.qlik.com/t5/QlikView/P-L-template/m-p/373626#M139054 2012-03-29T07:50:37Z Re: P&L template https://community.qlik.com/t5/QlikView/P-L-template/m-p/373627#M139055 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>This can be achieved usinf=g hirerchy function:</P><P></P><P>Here is the example..:</P></BODY></HTML> Thu, 29 Mar 2012 08:25:53 GMT https://community.qlik.com/t5/QlikView/P-L-template/m-p/373627#M139055 2012-03-29T08:25:53Z Re: P&L template https://community.qlik.com/t5/QlikView/P-L-template/m-p/373628#M139056 <HTML><HEAD></HEAD><BODY><P>I think you should try to use hirerchy function.</P></BODY></HTML> Thu, 29 Mar 2012 08:36:13 GMT https://community.qlik.com/t5/QlikView/P-L-template/m-p/373628#M139056 2012-03-29T08:36:13Z