topic Multi Horizontal Dimension In Qlikview in QlikView

topic Multi Horizontal Dimension In Qlikview in QlikView https://community.qlik.com/t5/QlikView/Multi-Horizontal-Dimension-In-Qlikview/m-p/1844139#M1215406 <P>Hi Team, </P><P>        I need to show multi horizontal dimension in Qlikview pivot table which is shown below and i have the data which is attached.</P><P> </P><P>I need to show high level dimension which i am unable to get it(ie. Interest, Dividends, Gain/Loses/Others</P><P> </P><TABLE><TBODY><TR><TD> </TD><TD>How to show this</TD><TD>Interest</TD><TD> </TD><TD>Dividends</TD><TD> </TD><TD>Gain/Loses</TD><TD> </TD><TD>Others</TD></TR><TR><TD>Entity</TD><TD>Account Name</TD><TD>Interest-1</TD><TD>Interest-2</TD><TD> </TD><TD>Dividends-1</TD><TD>Dividends-2</TD><TD> </TD><TD>Long-Term</TD><TD>Short-Term</TD><TD> </TD><TD>Others</TD></TR><TR><TD>A</TD><TD>A1</TD><TD>1000</TD><TD>3000</TD><TD> </TD><TD>400</TD><TD>600</TD><TD> </TD><TD>5000</TD><TD>4000</TD><TD> </TD><TD>600</TD></TR><TR><TD> </TD><TD>A2</TD><TD>1600</TD><TD>2000</TD><TD> </TD><TD>700</TD><TD>4990</TD><TD> </TD><TD>7280</TD><TD>5710</TD><TD> </TD><TD>7080</TD></TR><TR><TD>A Total</TD><TD> </TD><TD>2600</TD><TD>5000</TD><TD> </TD><TD>1100</TD><TD>5590</TD><TD> </TD><TD>12280</TD><TD>9710</TD><TD> </TD><TD>7680</TD></TR><TR><TD>B</TD><TD>B1</TD><TD>1000</TD><TD>3000</TD><TD> </TD><TD>400</TD><TD>600</TD><TD> </TD><TD>5000</TD><TD>4000</TD><TD> </TD><TD>600</TD></TR><TR><TD> </TD><TD>B2</TD><TD>1600</TD><TD>2000</TD><TD> </TD><TD>700</TD><TD>4990</TD><TD> </TD><TD>7280</TD><TD>5710</TD><TD> </TD><TD>7080</TD></TR><TR><TD>B Total</TD><TD> </TD><TD>2600</TD><TD>5000</TD><TD> </TD><TD>1100</TD><TD>5590</TD><TD> </TD><TD>12280</TD><TD>9710</TD><TD> </TD><TD>7680</TD></TR><TR><TD>Grand Total</TD><TD> </TD><TD>5200</TD><TD>10000</TD><TD> </TD><TD>2200</TD><TD>11180</TD><TD> </TD><TD>24560</TD><TD>19420</TD><TD> </TD><TD>15360</TD></TR></TBODY></TABLE> Fri, 08 Oct 2021 11:03:38 GMT sakthi266 2021-10-08T11:03:38Z Multi Horizontal Dimension In Qlikview https://community.qlik.com/t5/QlikView/Multi-Horizontal-Dimension-In-Qlikview/m-p/1844139#M1215406 <P>Hi Team, </P><P>        I need to show multi horizontal dimension in Qlikview pivot table which is shown below and i have the data which is attached.</P><P> </P><P>I need to show high level dimension which i am unable to get it(ie. Interest, Dividends, Gain/Loses/Others</P><P> </P><TABLE><TBODY><TR><TD> </TD><TD>How to show this</TD><TD>Interest</TD><TD> </TD><TD>Dividends</TD><TD> </TD><TD>Gain/Loses</TD><TD> </TD><TD>Others</TD></TR><TR><TD>Entity</TD><TD>Account Name</TD><TD>Interest-1</TD><TD>Interest-2</TD><TD> </TD><TD>Dividends-1</TD><TD>Dividends-2</TD><TD> </TD><TD>Long-Term</TD><TD>Short-Term</TD><TD> </TD><TD>Others</TD></TR><TR><TD>A</TD><TD>A1</TD><TD>1000</TD><TD>3000</TD><TD> </TD><TD>400</TD><TD>600</TD><TD> </TD><TD>5000</TD><TD>4000</TD><TD> </TD><TD>600</TD></TR><TR><TD> </TD><TD>A2</TD><TD>1600</TD><TD>2000</TD><TD> </TD><TD>700</TD><TD>4990</TD><TD> </TD><TD>7280</TD><TD>5710</TD><TD> </TD><TD>7080</TD></TR><TR><TD>A Total</TD><TD> </TD><TD>2600</TD><TD>5000</TD><TD> </TD><TD>1100</TD><TD>5590</TD><TD> </TD><TD>12280</TD><TD>9710</TD><TD> </TD><TD>7680</TD></TR><TR><TD>B</TD><TD>B1</TD><TD>1000</TD><TD>3000</TD><TD> </TD><TD>400</TD><TD>600</TD><TD> </TD><TD>5000</TD><TD>4000</TD><TD> </TD><TD>600</TD></TR><TR><TD> </TD><TD>B2</TD><TD>1600</TD><TD>2000</TD><TD> </TD><TD>700</TD><TD>4990</TD><TD> </TD><TD>7280</TD><TD>5710</TD><TD> </TD><TD>7080</TD></TR><TR><TD>B Total</TD><TD> </TD><TD>2600</TD><TD>5000</TD><TD> </TD><TD>1100</TD><TD>5590</TD><TD> </TD><TD>12280</TD><TD>9710</TD><TD> </TD><TD>7680</TD></TR><TR><TD>Grand Total</TD><TD> </TD><TD>5200</TD><TD>10000</TD><TD> </TD><TD>2200</TD><TD>11180</TD><TD> </TD><TD>24560</TD><TD>19420</TD><TD> </TD><TD>15360</TD></TR></TBODY></TABLE> Fri, 08 Oct 2021 11:03:38 GMT https://community.qlik.com/t5/QlikView/Multi-Horizontal-Dimension-In-Qlikview/m-p/1844139#M1215406 sakthi266 2021-10-08T11:03:38Z