topic Migration pivot? in QlikView https://community.qlik.com/t5/QlikView/Migration-pivot/m-p/201966#M59837 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I have been asked by my users to create a pivot table that shows the total values of customers that have migrated from one band to another band between two quarters. Which would look like a table they have which looks like this:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2360_sourceID:2360" /></P><P>So in this, we have the Sum of the VALUE field contained in the body of the table. The BAND field on the Y axis is quarter 1 only and the BAND field on the X axis is for quarter 2. So the problem here is that the BAND field is one field. All quarter data is in the same table and I have a field which says which quarter a record is from (QUARTER). I can have the user select the two quarters to compare, with input boxes for variables QUARTER_1 and QUARTER_2.</P><P>The shaded diagonal shows the sum of the VALUE field for customers where the BAND field is the same for records in QUARTER_1 and QUARTER_2. The values that lie outside this are the sum of the VALUE field for customers where the BAND field has changed over the different quarters.</P><P>Does anyone know whether this can be done with a pivot table while keeping with only one BAND field? I can't really make multiple BAND fields as the number of quarters in the data set is not constant.</P></BODY></HTML> Wed, 15 Sep 2010 12:18:42 GMT 2010-09-15T12:18:42Z Migration pivot? https://community.qlik.com/t5/QlikView/Migration-pivot/m-p/201966#M59837 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I have been asked by my users to create a pivot table that shows the total values of customers that have migrated from one band to another band between two quarters. Which would look like a table they have which looks like this:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2360_sourceID:2360" /></P><P>So in this, we have the Sum of the VALUE field contained in the body of the table. The BAND field on the Y axis is quarter 1 only and the BAND field on the X axis is for quarter 2. So the problem here is that the BAND field is one field. All quarter data is in the same table and I have a field which says which quarter a record is from (QUARTER). I can have the user select the two quarters to compare, with input boxes for variables QUARTER_1 and QUARTER_2.</P><P>The shaded diagonal shows the sum of the VALUE field for customers where the BAND field is the same for records in QUARTER_1 and QUARTER_2. The values that lie outside this are the sum of the VALUE field for customers where the BAND field has changed over the different quarters.</P><P>Does anyone know whether this can be done with a pivot table while keeping with only one BAND field? I can't really make multiple BAND fields as the number of quarters in the data set is not constant.</P></BODY></HTML> Wed, 15 Sep 2010 12:18:42 GMT https://community.qlik.com/t5/QlikView/Migration-pivot/m-p/201966#M59837 2010-09-15T12:18:42Z Migration pivot? https://community.qlik.com/t5/QlikView/Migration-pivot/m-p/201967#M59838 <HTML><HEAD></HEAD><BODY><P>At the moment I have had to concede to just doing the most recent quarter vs the second most recent quarter.</P></BODY></HTML> Thu, 16 Sep 2010 05:18:08 GMT https://community.qlik.com/t5/QlikView/Migration-pivot/m-p/201967#M59838 2010-09-16T05:18:08Z