topic Pivot table columns in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-columns/m-p/859662#M1005978 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Please check my screen shots.</P><P>screen1 - Right now my dashboard looks like that.</P><P>screen2 - requirement which I need to create.</P><P>like: Parent - Child-subchild</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1564px;"><TBODY><TR><TD class="xl65" height="25" width="113">EAD</TD><TD class="xl65" colspan="5" style="border-right: white 1.5pt solid;" width="492">Risk Weighted Assets (Current)</TD><TD class="xl65" colspan="5" style="border-left: medium none; border-right: white 1.5pt solid;" width="469">Capital (Current)</TD><TD class="xl65" colspan="5" style="border-left: medium none; border-right: white 1.5pt solid;" width="490">Total RWA including Notionals (Current)</TD></TR><TR><TD class="xl66" height="35" width="113">EAD (Current)</TD><TD class="xl66" colspan="2" width="201">Credit</TD><TD class="xl68" width="81">Market</TD><TD class="xl68" width="102">Ops</TD><TD class="xl67" width="108">Total</TD><TD class="xl66" style="border-left: medium none;" width="96">Deductions</TD><TD class="xl68" width="81">Expected Loss</TD><TD class="xl68" width="74">ALLL</TD><TD class="xl68" width="101">Expected Loss - ALLL</TD><TD class="xl67" width="117">Total&nbsp;&nbsp; Capital</TD><TD class="xl76" rowspan="2" style="border-bottom: white 1.5pt solid;" width="100">Capital Deductions Notional</TD><TD class="xl78" rowspan="2" style="border-bottom: white 1.5pt solid;" width="100">EL-ALLL Shortfall Notional</TD><TD class="xl78" rowspan="2" style="border-bottom: white 1.5pt solid;" width="95">Intangible Assets Notional</TD><TD class="xl78" rowspan="2" style="border-bottom: white 1.5pt solid;" width="95">CRD IV Notional</TD><TD class="xl78" rowspan="2" style="border-bottom: white 1.5pt solid;" width="100">Total RWA plus Notionals</TD></TR><TR><TD class="xl69" height="45" width="113"></TD><TD class="xl73" width="108">CCR</TD><TD class="xl72" width="93">NCCR</TD><TD class="xl71" width="81"></TD><TD class="xl71" width="102"></TD><TD class="xl70" width="108"></TD><TD class="xl69" style="border-left: medium none;" width="96"></TD><TD class="xl71" width="81"></TD><TD class="xl71" width="74"></TD><TD class="xl71" width="101"></TD><TD class="xl71" width="117"></TD></TR></TBODY></TABLE><P></P><P></P><P>Headings(EAD,Risk Weighted Assets (Current),Capital (Current).......),subchild(CCR,NCCR) are not in my data.. so how to do it. Can some one please help me.</P></BODY></HTML> Thu, 14 May 2015 09:21:12 GMT priyarane 2015-05-14T09:21:12Z Pivot table columns https://community.qlik.com/t5/QlikView/Pivot-table-columns/m-p/859662#M1005978 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Please check my screen shots.</P><P>screen1 - Right now my dashboard looks like that.</P><P>screen2 - requirement which I need to create.</P><P>like: Parent - Child-subchild</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1564px;"><TBODY><TR><TD class="xl65" height="25" width="113">EAD</TD><TD class="xl65" colspan="5" style="border-right: white 1.5pt solid;" width="492">Risk Weighted Assets (Current)</TD><TD class="xl65" colspan="5" style="border-left: medium none; border-right: white 1.5pt solid;" width="469">Capital (Current)</TD><TD class="xl65" colspan="5" style="border-left: medium none; border-right: white 1.5pt solid;" width="490">Total RWA including Notionals (Current)</TD></TR><TR><TD class="xl66" height="35" width="113">EAD (Current)</TD><TD class="xl66" colspan="2" width="201">Credit</TD><TD class="xl68" width="81">Market</TD><TD class="xl68" width="102">Ops</TD><TD class="xl67" width="108">Total</TD><TD class="xl66" style="border-left: medium none;" width="96">Deductions</TD><TD class="xl68" width="81">Expected Loss</TD><TD class="xl68" width="74">ALLL</TD><TD class="xl68" width="101">Expected Loss - ALLL</TD><TD class="xl67" width="117">Total&nbsp;&nbsp; Capital</TD><TD class="xl76" rowspan="2" style="border-bottom: white 1.5pt solid;" width="100">Capital Deductions Notional</TD><TD class="xl78" rowspan="2" style="border-bottom: white 1.5pt solid;" width="100">EL-ALLL Shortfall Notional</TD><TD class="xl78" rowspan="2" style="border-bottom: white 1.5pt solid;" width="95">Intangible Assets Notional</TD><TD class="xl78" rowspan="2" style="border-bottom: white 1.5pt solid;" width="95">CRD IV Notional</TD><TD class="xl78" rowspan="2" style="border-bottom: white 1.5pt solid;" width="100">Total RWA plus Notionals</TD></TR><TR><TD class="xl69" height="45" width="113"></TD><TD class="xl73" width="108">CCR</TD><TD class="xl72" width="93">NCCR</TD><TD class="xl71" width="81"></TD><TD class="xl71" width="102"></TD><TD class="xl70" width="108"></TD><TD class="xl69" style="border-left: medium none;" width="96"></TD><TD class="xl71" width="81"></TD><TD class="xl71" width="74"></TD><TD class="xl71" width="101"></TD><TD class="xl71" width="117"></TD></TR></TBODY></TABLE><P></P><P></P><P>Headings(EAD,Risk Weighted Assets (Current),Capital (Current).......),subchild(CCR,NCCR) are not in my data.. so how to do it. Can some one please help me.</P></BODY></HTML> Thu, 14 May 2015 09:21:12 GMT https://community.qlik.com/t5/QlikView/Pivot-table-columns/m-p/859662#M1005978 priyarane 2015-05-14T09:21:12Z