topic Re: Pivot table with fixed coluns in App Development https://community.qlik.com/t5/App-Development/Pivot-table-with-fixed-coluns/m-p/1149675#M20587 <HTML><HEAD></HEAD><BODY><P>For some reason, I am unable to make the Diff column work due to unable to divide it with a Only(Meta). Other than that, everything is working</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133979_Capture.PNG" style="height: 101px; width: 620px;" /></P><P></P><P>Please check if this is what you wanted. Attaching the qvf for your review.</P></BODY></HTML> Mon, 08 Aug 2016 23:28:54 GMT sunny_talwar 2016-08-08T23:28:54Z Pivot table with fixed coluns https://community.qlik.com/t5/App-Development/Pivot-table-with-fixed-coluns/m-p/1149672#M20584 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I needed build a table like this image</P><P><IMG alt="2016-08-08_1420.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133942_2016-08-08_1420.png" style="height: 150px; width: 620px;" /></P><P></P><P>- Data is dynamic, depends&nbsp; user selection</P><P>- Meta,Total,Diff is measures fixed</P><P></P><P>In Qliksense i don´t found one soluction for it.</P></BODY></HTML> Mon, 08 Aug 2016 17:25:02 GMT https://community.qlik.com/t5/App-Development/Pivot-table-with-fixed-coluns/m-p/1149672#M20584 2016-08-08T17:25:02Z Re: Pivot table with fixed coluns https://community.qlik.com/t5/App-Development/Pivot-table-with-fixed-coluns/m-p/1149673#M20585 <HTML><HEAD></HEAD><BODY><P>Would you be able to post an Excel file with the raw data to get this solution?</P></BODY></HTML> Mon, 08 Aug 2016 17:51:46 GMT https://community.qlik.com/t5/App-Development/Pivot-table-with-fixed-coluns/m-p/1149673#M20585 sunny_talwar 2016-08-08T17:51:46Z Re: Pivot table with fixed coluns https://community.qlik.com/t5/App-Development/Pivot-table-with-fixed-coluns/m-p/1149674#M20586 <HTML><HEAD></HEAD><BODY><P>I created a qvf with the records.</P></BODY></HTML> Mon, 08 Aug 2016 18:11:17 GMT https://community.qlik.com/t5/App-Development/Pivot-table-with-fixed-coluns/m-p/1149674#M20586 2016-08-08T18:11:17Z Re: Pivot table with fixed coluns https://community.qlik.com/t5/App-Development/Pivot-table-with-fixed-coluns/m-p/1149675#M20587 <HTML><HEAD></HEAD><BODY><P>For some reason, I am unable to make the Diff column work due to unable to divide it with a Only(Meta). Other than that, everything is working</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133979_Capture.PNG" style="height: 101px; width: 620px;" /></P><P></P><P>Please check if this is what you wanted. Attaching the qvf for your review.</P></BODY></HTML> Mon, 08 Aug 2016 23:28:54 GMT https://community.qlik.com/t5/App-Development/Pivot-table-with-fixed-coluns/m-p/1149675#M20587 sunny_talwar 2016-08-08T23:28:54Z