topic Pivot Structure - display migration in QlikView https://community.qlik.com/t5/QlikView/Pivot-Structure-display-migration/m-p/965600#M528040 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>at the moment I fail preparing a pivot table.</P><P>My data model is as followed:</P><P>The primary key is the IdentNo. For each IdentNo there are two Versions (=years) available (as rows). I now want to show the migration of the two versions (e.g. IdentNo 5002 has Classification P01A in 2014 and P01B in 2015).</P><P>The Privot table should look as follows</P><P>Category - Structure - SubCategory - Classification (2014) - Classification 2015 - sum(Always1) - sum(Points)</P><P>so that the user is able to analyse which classification of last year migrates in which way.</P><P></P><P>See attached my example.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 13 Oct 2015 07:57:11 GMT richters 2015-10-13T07:57:11Z Pivot Structure - display migration https://community.qlik.com/t5/QlikView/Pivot-Structure-display-migration/m-p/965600#M528040 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>at the moment I fail preparing a pivot table.</P><P>My data model is as followed:</P><P>The primary key is the IdentNo. For each IdentNo there are two Versions (=years) available (as rows). I now want to show the migration of the two versions (e.g. IdentNo 5002 has Classification P01A in 2014 and P01B in 2015).</P><P>The Privot table should look as follows</P><P>Category - Structure - SubCategory - Classification (2014) - Classification 2015 - sum(Always1) - sum(Points)</P><P>so that the user is able to analyse which classification of last year migrates in which way.</P><P></P><P>See attached my example.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 13 Oct 2015 07:57:11 GMT https://community.qlik.com/t5/QlikView/Pivot-Structure-display-migration/m-p/965600#M528040 richters 2015-10-13T07:57:11Z Re: Pivot Structure - display migration https://community.qlik.com/t5/QlikView/Pivot-Structure-display-migration/m-p/965601#M528041 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Fri, 23 Oct 2015 14:02:11 GMT https://community.qlik.com/t5/QlikView/Pivot-Structure-display-migration/m-p/965601#M528041 Gysbert_Wassenaar 2015-10-23T14:02:11Z