topic Pivot table with more dimensions in App Development https://community.qlik.com/t5/App-Development/Pivot-table-with-more-dimensions/m-p/33614#M2247 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>the thing I'm working on is that pivot table should have data split by month. So I need to count different values from different sources and have them in one table, filtered by month, but every data source has own "date" field. <BR />Please find attached screenshot where my pivot table doesn't work properly, and below 2 simple tables with proper data in it. I think that "Columns" section needs to be rebuilt but I don't know how. </P><P>The thing is that I need data from these 2 simple tables in 1 pivot table. Is it possible, if yes - how? </P><P><IMG alt="qlik2.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193556_qlik2.PNG" style="height: 313px; width: 620px;" /></P></BODY></HTML> Thu, 15 Feb 2018 16:57:01 GMT Anonymous 2018-02-15T16:57:01Z Pivot table with more dimensions https://community.qlik.com/t5/App-Development/Pivot-table-with-more-dimensions/m-p/33614#M2247 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>the thing I'm working on is that pivot table should have data split by month. So I need to count different values from different sources and have them in one table, filtered by month, but every data source has own "date" field. <BR />Please find attached screenshot where my pivot table doesn't work properly, and below 2 simple tables with proper data in it. I think that "Columns" section needs to be rebuilt but I don't know how. </P><P>The thing is that I need data from these 2 simple tables in 1 pivot table. Is it possible, if yes - how? </P><P><IMG alt="qlik2.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193556_qlik2.PNG" style="height: 313px; width: 620px;" /></P></BODY></HTML> Thu, 15 Feb 2018 16:57:01 GMT https://community.qlik.com/t5/App-Development/Pivot-table-with-more-dimensions/m-p/33614#M2247 Anonymous 2018-02-15T16:57:01Z