topic Dimension + calculated value in QlikView https://community.qlik.com/t5/QlikView/Dimension-calculated-value/m-p/484688#M1146962 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have two date fields. One is registration year and second is bill year. I also counted unique serialno under each year as you see in </P><P>the picture bellow.</P><P>Then I created pivot table which contains bouth data fields and one expression where I count how many workorder I have under each year.</P><P>My quastion is: Is it possible to somehow show YearFREGD and YearBILLD together with figures from previous expressions?</P><P></P><P>For example: YearFREGD =&gt; 2007(707), YearBILLD =&gt; 2006(28), 2007(610), 2008(577), 2009(476), 2010(428), 2011(394), 2012(369)</P><P>and 2013(301) </P><P><IMG __jive_id="45336" class="jive-image-thumbnail jive-image" onclick="" alt="1.PNG" src="https://community.qlik.com/legacyfs/online/45336_1.PNG" width="450" /></P><P>The new table should look like this:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2006(28)&nbsp; 2007(610)&nbsp; 2008(577)&nbsp; 2009(476)&nbsp; 2010(428)&nbsp; 2011(394)&nbsp; 2012(369)&nbsp; 2013(301)</P><P>2007(707)&nbsp;&nbsp;&nbsp;&nbsp; 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3430&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1920&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1647&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1532&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1414&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 856</P><P></P><P>Thanks</P></BODY></HTML> Mon, 12 Aug 2013 13:31:50 GMT 2013-08-12T13:31:50Z Dimension + calculated value https://community.qlik.com/t5/QlikView/Dimension-calculated-value/m-p/484688#M1146962 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have two date fields. One is registration year and second is bill year. I also counted unique serialno under each year as you see in </P><P>the picture bellow.</P><P>Then I created pivot table which contains bouth data fields and one expression where I count how many workorder I have under each year.</P><P>My quastion is: Is it possible to somehow show YearFREGD and YearBILLD together with figures from previous expressions?</P><P></P><P>For example: YearFREGD =&gt; 2007(707), YearBILLD =&gt; 2006(28), 2007(610), 2008(577), 2009(476), 2010(428), 2011(394), 2012(369)</P><P>and 2013(301) </P><P><IMG __jive_id="45336" class="jive-image-thumbnail jive-image" onclick="" alt="1.PNG" src="https://community.qlik.com/legacyfs/online/45336_1.PNG" width="450" /></P><P>The new table should look like this:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2006(28)&nbsp; 2007(610)&nbsp; 2008(577)&nbsp; 2009(476)&nbsp; 2010(428)&nbsp; 2011(394)&nbsp; 2012(369)&nbsp; 2013(301)</P><P>2007(707)&nbsp;&nbsp;&nbsp;&nbsp; 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3430&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1920&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1647&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1532&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1414&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 856</P><P></P><P>Thanks</P></BODY></HTML> Mon, 12 Aug 2013 13:31:50 GMT https://community.qlik.com/t5/QlikView/Dimension-calculated-value/m-p/484688#M1146962 2013-08-12T13:31:50Z