topic PnL hierarchy field with indentations in App Development https://community.qlik.com/t5/App-Development/PnL-hierarchy-field-with-indentations/m-p/1290676#M27216 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>can somebody help me with this problem.</P><P>I have a single field which reflects the account hierarchy with a lof of indentations like that:</P><P></P><P><IMG __jive_id="151915" alt="Capture.PNG" class="jive-image image-1" height="309" src="https://community.qlik.com/legacyfs/online/151915_Capture.PNG" style="height: 308.725px; width: 233px;" width="233" /></P><P></P><P>I would like to transform the indent hierarchy in a flat hierarchy like (we have L1-L12). Is there a way to achieve the following output assuming that the indent Levels have always the same paddings?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Key</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 5</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 6</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 7</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 8</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 9</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 10</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 11</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 12</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">NetInc</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">NetInc</TD><TD style="padding: 2px;">OpProf</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">NetInc</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpProf</SPAN></TD><TD style="padding: 2px;">OpResult</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">NetInc</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpProf</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpResult</SPAN></TD><TD style="padding: 2px;">OpRev</TD><TD style="padding: 2px;">NetIntIncProv</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">NetInc</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpProf</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpResult</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpRev</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">NetIntIncProv</SPAN></TD><TD style="padding: 2px;">NetIntInc</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD></TD><TD><SPAN style="font-size: 13.3333px;">NetInc</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">OpProf</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">OpResult</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">OpRev</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">NetIntIncProv</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">NetIntInc</SPAN></TD><TD>LB_DB</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD>NetInc</TD><TD>OpProf</TD><TD>OpResult</TD><TD>OpRev</TD><TD>NetIntIncProv</TD><TD>NetIntInc</TD><TD>LB_DB</TD><TD>LB</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD>NetInc</TD><TD>OpProf</TD><TD>OpResult</TD><TD>OpRev</TD><TD>NetIntIncProv</TD><TD>NetIntInc</TD><TD>LB_DB</TD><TD>LB</TD><TD>5110R</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD>NetInc</TD><TD>OpProf</TD><TD>OpResult</TD><TD>OpRev</TD><TD>NetIntIncProv</TD><TD>NetIntInc</TD><TD>LB_DB</TD><TD>LB</TD><TD>5115R</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>Attached you can find some dummy data of the delivered data.</P><P></P><P>Thanks and regards,</P><P>Patric</P></BODY></HTML> Fri, 03 Feb 2017 13:51:39 GMT pamaxeed 2017-02-03T13:51:39Z PnL hierarchy field with indentations https://community.qlik.com/t5/App-Development/PnL-hierarchy-field-with-indentations/m-p/1290676#M27216 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>can somebody help me with this problem.</P><P>I have a single field which reflects the account hierarchy with a lof of indentations like that:</P><P></P><P><IMG __jive_id="151915" alt="Capture.PNG" class="jive-image image-1" height="309" src="https://community.qlik.com/legacyfs/online/151915_Capture.PNG" style="height: 308.725px; width: 233px;" width="233" /></P><P></P><P>I would like to transform the indent hierarchy in a flat hierarchy like (we have L1-L12). Is there a way to achieve the following output assuming that the indent Levels have always the same paddings?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Key</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 5</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 6</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 7</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 8</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 9</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 10</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 11</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level 12</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">NetInc</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">NetInc</TD><TD style="padding: 2px;">OpProf</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">NetInc</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpProf</SPAN></TD><TD style="padding: 2px;">OpResult</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">NetInc</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpProf</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpResult</SPAN></TD><TD style="padding: 2px;">OpRev</TD><TD style="padding: 2px;">NetIntIncProv</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">NetInc</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpProf</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpResult</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">OpRev</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">NetIntIncProv</SPAN></TD><TD style="padding: 2px;">NetIntInc</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD></TD><TD><SPAN style="font-size: 13.3333px;">NetInc</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">OpProf</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">OpResult</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">OpRev</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">NetIntIncProv</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">NetIntInc</SPAN></TD><TD>LB_DB</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD>NetInc</TD><TD>OpProf</TD><TD>OpResult</TD><TD>OpRev</TD><TD>NetIntIncProv</TD><TD>NetIntInc</TD><TD>LB_DB</TD><TD>LB</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD>NetInc</TD><TD>OpProf</TD><TD>OpResult</TD><TD>OpRev</TD><TD>NetIntIncProv</TD><TD>NetIntInc</TD><TD>LB_DB</TD><TD>LB</TD><TD>5110R</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD>NetInc</TD><TD>OpProf</TD><TD>OpResult</TD><TD>OpRev</TD><TD>NetIntIncProv</TD><TD>NetIntInc</TD><TD>LB_DB</TD><TD>LB</TD><TD>5115R</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>Attached you can find some dummy data of the delivered data.</P><P></P><P>Thanks and regards,</P><P>Patric</P></BODY></HTML> Fri, 03 Feb 2017 13:51:39 GMT https://community.qlik.com/t5/App-Development/PnL-hierarchy-field-with-indentations/m-p/1290676#M27216 pamaxeed 2017-02-03T13:51:39Z