Pivot Table Inline

[manish_kumar]

Hi

I am getting issue in creating pivot table with inline.

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.

Attaching the file for the reference.

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.

[Gysbert_Wassenaar]

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.