topic Is it possible to create a calculated value on a row? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335770#M576911 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>To display chart like this use Pivot table, use Month as Dimension and write expressions for Sales, Costs1, Margin1, Costs2 and Margin2.&nbsp; </P><P></P><P>No drag the Month dimension along to the top of the table and drag expressions to vertically.&nbsp; </P><P></P><P>If possible, can you attach a sample file.</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 04 Apr 2012 04:32:07 GMT jagan 2012-04-04T04:32:07Z Is it possible to create a calculated value on a row? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335769#M576910 <HTML><HEAD></HEAD><BODY><P>Hi is it possible to create a calculated value on a row? </P><P>For example I have Sales, Costs1 and Costs2, is it possible to create the following:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp; Mar</P><P>Row n1: Sales</P><P>Row n2: Costs1</P><P>Row n3: Margin1 (Sales-Costs1)</P><P>Row n4: Costs2</P><P>Row n5: Margin2 (Margin1-Costs2)</P><P></P><P></P><P>Thanks!</P><P></P><P>Camilo Lund R.</P></BODY></HTML> Tue, 03 Apr 2012 20:30:30 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335769#M576910 camilo 2012-04-03T20:30:30Z Is it possible to create a calculated value on a row? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335770#M576911 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>To display chart like this use Pivot table, use Month as Dimension and write expressions for Sales, Costs1, Margin1, Costs2 and Margin2.&nbsp; </P><P></P><P>No drag the Month dimension along to the top of the table and drag expressions to vertically.&nbsp; </P><P></P><P>If possible, can you attach a sample file.</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 04 Apr 2012 04:32:07 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335770#M576911 jagan 2012-04-04T04:32:07Z Re: Is it possible to create a calculated value on a row? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335771#M576912 <HTML><HEAD></HEAD><BODY><P>Hi Jagan,</P><P></P><P>Im attaching an example hoppfully it will be more clear.</P><P>The idea would be to create a margin1 between Cost1 and Cost2 and a margin2 at the bottom.</P><P></P><P>Margin1=Sales+Cost1</P><P>Margin2=Sales+Cost1+Cost2</P><P></P><P>Thanks,</P><P></P><P>Camilo</P></BODY></HTML> Wed, 04 Apr 2012 12:54:18 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335771#M576912 camilo 2012-04-04T12:54:18Z Re: Is it possible to create a calculated value on a row? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335772#M576913 <HTML><HEAD></HEAD><BODY><P>If I´m not beeing clear enough please tell me.</P><P></P><P>Thanks,</P><P></P><P>Camilo</P></BODY></HTML> Wed, 04 Apr 2012 18:47:33 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335772#M576913 camilo 2012-04-04T18:47:33Z Re: Is it possible to create a calculated value on a row? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335773#M576914 <HTML><HEAD></HEAD><BODY><P>Remove the Group Dimension.</P><P></P><P>Create expressions </P><P>Sales:</P><P>sum({&lt;Group={'Sales'} USD)</P><P>Cost1</P><P>sum({&lt;Group={'Cost1'} USD)</P><P>Margin1:</P><P>sum({&lt;Group={'Sales'} USD)-sum({&lt;Group={'Cost1'} USD)</P><P>Cost2</P><P>sum({&lt;Group={'Cost2'} USD)</P><P>Margin2</P><P>(sum({&lt;Group={'Sales'} USD)-sum({&lt;Group={'Cost1'} USD))-sum({&lt;Group={'Cost2'} USD)</P></BODY></HTML> Wed, 04 Apr 2012 18:58:24 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335773#M576914 2012-04-04T18:58:24Z Re: Is it possible to create a calculated value on a row? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335774#M576915 <HTML><HEAD></HEAD><BODY><P>Thanks it worked, it seems an &gt;} was mising on the set analysis commands but it worked!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Wed, 04 Apr 2012 20:40:25 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335774#M576915 camilo 2012-04-04T20:40:25Z Re: Is it possible to create a calculated value on a row? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335775#M576916 <HTML><HEAD></HEAD><BODY><P>Oh, Yeah sorry about that. It has been a long day <span class="lia-unicode-emoji" title=":face_with_tongue:">😛</span></P></BODY></HTML> Wed, 04 Apr 2012 20:45:05 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-a-calculated-value-on-a-row/m-p/335775#M576916 2012-04-04T20:45:05Z