topic Expressions between Dimensions in Pivot in QlikView https://community.qlik.com/t5/QlikView/Expressions-between-Dimensions-in-Pivot/m-p/720618#M542060 <HTML><HEAD></HEAD><BODY><P>Original Pivot table</P><P><IMG __jive_id="60935" alt="Old.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/60935_Old.PNG.png" style="width: 620px; height: 48px;" /></P><P>Goal</P><P><IMG __jive_id="60936" alt="New.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/60936_New.PNG.png" style="width: 620px; height: 53px;" /></P><P></P><P>Hi,</P><P></P><P>I want to make the 1st picture (Original Pivot table) to the 2nd one (Goal), what should I do?</P><P>Blue columns are expressions and white ones are dimensions. Thx!</P></BODY></HTML> Fri, 20 Jun 2014 19:29:32 GMT 2014-06-20T19:29:32Z Expressions between Dimensions in Pivot https://community.qlik.com/t5/QlikView/Expressions-between-Dimensions-in-Pivot/m-p/720618#M542060 <HTML><HEAD></HEAD><BODY><P>Original Pivot table</P><P><IMG __jive_id="60935" alt="Old.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/60935_Old.PNG.png" style="width: 620px; height: 48px;" /></P><P>Goal</P><P><IMG __jive_id="60936" alt="New.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/60936_New.PNG.png" style="width: 620px; height: 53px;" /></P><P></P><P>Hi,</P><P></P><P>I want to make the 1st picture (Original Pivot table) to the 2nd one (Goal), what should I do?</P><P>Blue columns are expressions and white ones are dimensions. Thx!</P></BODY></HTML> Fri, 20 Jun 2014 19:29:32 GMT https://community.qlik.com/t5/QlikView/Expressions-between-Dimensions-in-Pivot/m-p/720618#M542060 2014-06-20T19:29:32Z Re: Expressions between Dimensions in Pivot https://community.qlik.com/t5/QlikView/Expressions-between-Dimensions-in-Pivot/m-p/720619#M542061 <HTML><HEAD></HEAD><BODY><P>You can create these columns as calculated dimensions instead of expressions.</P></BODY></HTML> Fri, 20 Jun 2014 20:38:52 GMT https://community.qlik.com/t5/QlikView/Expressions-between-Dimensions-in-Pivot/m-p/720619#M542061 Anonymous 2014-06-20T20:38:52Z