topic Re: Pivot Table Inline in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Inline/m-p/1400107#M424549 <HTML><HEAD></HEAD><BODY><P>Your two tables are not associated. So if you use fields from the two tables in one pivot table you get a Cartesian product. Every record from one table is combined with all the records from the other table. You need to rename a field so Qlikview can associate the tables on the fields the tables have in common.</P></BODY></HTML> Thu, 30 Nov 2017 07:22:57 GMT Gysbert_Wassenaar 2017-11-30T07:22:57Z Pivot Table Inline https://community.qlik.com/t5/QlikView/Pivot-Table-Inline/m-p/1400106#M424548 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am getting issue in creating pivot table with inline.</P><P></P><P>I want to create two dimensions in the pivot with Inline and one dimension is coming from data model. And from the dimension value it should expand and collapse. But when I am collapsing the dimension the values are not getting populated. Values are getting populated only when the table is fully expanded.</P><P></P><P>Attaching the file for the reference.</P><P></P><P>In the file output required is when the 1st column is collapsed it should show the sum of Paid + Payable and when it is expanded it should show the bifurcations also.</P></BODY></HTML> Thu, 30 Nov 2017 07:16:57 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Inline/m-p/1400106#M424548 manish_kumar 2017-11-30T07:16:57Z Re: Pivot Table Inline https://community.qlik.com/t5/QlikView/Pivot-Table-Inline/m-p/1400107#M424549 <HTML><HEAD></HEAD><BODY><P>Your two tables are not associated. So if you use fields from the two tables in one pivot table you get a Cartesian product. Every record from one table is combined with all the records from the other table. You need to rename a field so Qlikview can associate the tables on the fields the tables have in common.</P></BODY></HTML> Thu, 30 Nov 2017 07:22:57 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Inline/m-p/1400107#M424549 Gysbert_Wassenaar 2017-11-30T07:22:57Z