topic Qlikview Pivot Table Issue in QlikView

topic Qlikview Pivot Table Issue in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Pivot-Table-Issue/m-p/1844128#M1215405 <P>Hi team, </P><P>           Please refer below the data which is in Qlikview need to show the Pivot table in multiple dimension as mentioned below</P><TABLE><TBODY><TR><TD>Entity</TD><TD>Account Name</TD><TD>Type</TD><TD>Date</TD><TD>Amount1</TD><TD>Amount2</TD><TD>Amount3</TD><TD>Amount4</TD></TR><TR><TD>A</TD><TD>A1</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>200</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>300</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2000</TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2500</TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>300</TD></TR><TR><TD>A</TD><TD>A1</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>200</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>300</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2000</TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2500</TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>300</TD></TR><TR><TD>A</TD><TD>A2</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>100</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1700</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>250</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>350</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>250</TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>1640</TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>500</TD></TR><TR><TD>A</TD><TD>A2</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>300</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>450</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>4640</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>5460</TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>5640</TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>6580</TD></TR><TR><TD>B</TD><TD>B1</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>200</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>300</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2000</TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2500</TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>300</TD></TR><TR><TD>B</TD><TD>B1</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>200</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>300</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2000</TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2500</TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>300</TD></TR><TR><TD>B</TD><TD>B2</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>100</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1700</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>250</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>350</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>250</TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>1640</TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>500</TD></TR><TR><TD>B</TD><TD>B2</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>300</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>450</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>4640</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>5460</TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>5640</TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>6580</TD></TR></TBODY></TABLE><P> </P><P> </P><P>Also attached in Excel as well</P><P> </P><P>Thanks and Regards, <BR />Sakthivel.S</P><P> </P> Fri, 08 Oct 2021 10:43:53 GMT sakthi266 2021-10-08T10:43:53Z Qlikview Pivot Table Issue https://community.qlik.com/t5/QlikView/Qlikview-Pivot-Table-Issue/m-p/1844128#M1215405 <P>Hi team, </P><P>           Please refer below the data which is in Qlikview need to show the Pivot table in multiple dimension as mentioned below</P><TABLE><TBODY><TR><TD>Entity</TD><TD>Account Name</TD><TD>Type</TD><TD>Date</TD><TD>Amount1</TD><TD>Amount2</TD><TD>Amount3</TD><TD>Amount4</TD></TR><TR><TD>A</TD><TD>A1</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>200</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>300</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2000</TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2500</TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>300</TD></TR><TR><TD>A</TD><TD>A1</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>200</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>300</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2000</TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2500</TD><TD> </TD></TR><TR><TD>A</TD><TD>A1</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>300</TD></TR><TR><TD>A</TD><TD>A2</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>100</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1700</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>250</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>350</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>250</TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>1640</TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>500</TD></TR><TR><TD>A</TD><TD>A2</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>300</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>450</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>4640</TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>5460</TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>5640</TD><TD> </TD></TR><TR><TD>A</TD><TD>A2</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>6580</TD></TR><TR><TD>B</TD><TD>B1</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>200</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>300</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2000</TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2500</TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>300</TD></TR><TR><TD>B</TD><TD>B1</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>200</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>300</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2000</TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>2500</TD><TD> </TD></TR><TR><TD>B</TD><TD>B1</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>300</TD></TR><TR><TD>B</TD><TD>B2</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>100</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>1700</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>250</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>350</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>250</TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>1640</TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>500</TD></TR><TR><TD>B</TD><TD>B2</TD><TD>I-1</TD><TD>01-10-2021</TD><TD>1500</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>I-2</TD><TD>01-10-2021</TD><TD>300</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>D-1</TD><TD>01-10-2021</TD><TD> </TD><TD>450</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>D-2</TD><TD>01-10-2021</TD><TD> </TD><TD>4640</TD><TD> </TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>ST</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>5460</TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>LT</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD>5640</TD><TD> </TD></TR><TR><TD>B</TD><TD>B2</TD><TD>Oth</TD><TD>01-10-2021</TD><TD> </TD><TD> </TD><TD> </TD><TD>6580</TD></TR></TBODY></TABLE><P> </P><P> </P><P>Also attached in Excel as well</P><P> </P><P>Thanks and Regards, <BR />Sakthivel.S</P><P> </P> Fri, 08 Oct 2021 10:43:53 GMT https://community.qlik.com/t5/QlikView/Qlikview-Pivot-Table-Issue/m-p/1844128#M1215405 sakthi266 2021-10-08T10:43:53Z